Cumulate function
Options
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
0
Answers

Try the CUMULATE or MOVINGSUM functions.
OR
It should be something like,
IF Current Quarter? THEN MOVINGSUM(Output,2,1,SUM) ELSE Output
0 
IF Ending OnHand > 0 THEN Output + PREVIOUS(Output) ELSE 0
Give it a try.0 
Hi @tompatrick.ting
Try to Use Moving sum or Previous function instead of cumulate0