Cumulate function
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