CourtneyRapp
6 years agoQrew Cadet
Re: Sum product in one column by day/date in another column
Hello again,
I wasn't able to make the comment directly above work for what I need, however, I was able to make the original formula for the cumulative sum to work.
My next question is then how do I get those results to convert to numbers for formula use? Basically if I want to subtract the cumulative results from another summary field number, is there a way to do that?
Based on a preliminary search I'm not seeing anything on like a 'ToNumber' for rich text formula fields...
I wasn't able to make the comment directly above work for what I need, however, I was able to make the original formula for the cumulative sum to work.
My next question is then how do I get those results to convert to numbers for formula use? Basically if I want to subtract the cumulative results from another summary field number, is there a way to do that?
Based on a preliminary search I'm not seeing anything on like a 'ToNumber' for rich text formula fields...