Forum Discussion
Cumulative total not working
Hi I tried doing cumulative total for my data, however for some of the rows it is not working. Attached is screenshot of the data as well as formula. Look at the bottom highlighed in squate. Any...
Prasad84,
What result would you like to get for the highlighted part? For 0.035 and 0.0352, Round() function return 0.035, thus the cummulative value would be -(5.42+1.23).
Regards,
Lydia
At 0.035 it is starting total afresh and not cumulative which will be sum of sales of all the rows where multiplier is less than 0.035. If you notice the rows at top they add cumulatively. Not sure what is driving this.
Prasad84,
Please share complete data of your table so that I can test.
Regards,
Lydia