Hi all ! while doing cummulative sum it is getting added all values, but skiping 0 value and adding the immediate nxt value. Plz suggest solution

[#1]

Hi all ! while doing cummulative sum it is getting added all values, but skiping 0 value and adding the immediate nxt value. Plz suggest solution

[Gysbert_Wassenaar]

Can you explain what you expect? In a cumulative sum a value 0 does not change the cumulative value. That's not skipping the value, but simple adding 0.

[#3]

ya, it is not adding 0. it is adding just next value to it and showing in cumulative field.

Logic:

if( RowNo()>1,if((month([Date_LD]) =month(Previous([Date_LD]))),([Sales_LD] + Peek([Cum Sales])),[Sales_LD]),[Sales_LD]) As [Cum Sales];

[Gysbert_Wassenaar]

You mean the Suppress Zero Values option is enabled? Try disabling it on the Presentation tab.

[#5]

Plz chk it,