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

Answers