How can One Create a Dynamic Movingsum
Hi,
I'm doing a movingsum and what to achieve these set of rules.
IF Actuals then movingsum(data, -11, 0, average) else IF Forecast I want to do for Jan 24 movingsum(data, -10, 0, average), for Feb movingsum(data, -9, 0, average) for Mar movingsum(data, -8, 0, average) and so on How can I achieve this in one line item.
I have tried many methods it didn't work. Please any workaround will be appreciated. Thanks.
Best Answer
-
Hi @innocent You can achieve this by creating an extra line item where you can manually write -10 for Jan 24,-9 for feb 24 and so on and in moving sum instead of -10 and all you can refer that newly created line item.
If you don't want to write it manually you can write a formula in newly created line item ie, with the help of month number as shown below.
You can refer this line item 2 in your moving sum
0
Answers
-
Hi @AkhilEmmanual thank you so much for the response and the example you provided, it was really helpful.
1