Forum Discussion

Prasad84's avatar
Prasad84
Advocate I
8 years ago

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. Anyone idea on the reason.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

    • Prasad84's avatar
      Prasad84
      Advocate I
      8 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Prasad84,

        Please share complete data of your table so that I can test.

        Regards,
        Lydia