Cumulate function

tompatrick.ting

Hi,

How can i calculate the quarter that will fill my ending on hand?

Example : I have an ending on hand on Q3 fy20, i need to show in my Output Cumulate the summation of my Q2 fy20 and Q3 fy20 only or the total of 7 instead of 9.

Thanks in advance for helping.

Tom

Dikshant

Try the CUMULATE or MOVINGSUM functions.

https://help.anaplan.com/cumulate-1173a903-81bb-4838-a4d0-1c9f9c739aa3 OR https://help.anaplan.com/movingsum-37394929-ea62-4e55-9655-b8c8c2732679

It should be something like,

IF Current Quarter? THEN MOVINGSUM(Output,-2,-1,SUM) ELSE Output

SriNitya

IF Ending OnHand > 0 THEN Output + PREVIOUS(Output) ELSE 0
Give it a try.

PujithaB

Hi @tompatrick.ting

Try to Use Moving sum or Previous function instead of cumulate