How calculate the average value of last 24 months for a ratio

[alexrajo]

Dear All,

I have a requirement to get the average value of the last 24 months for a ratio. I read about how to do this for a rolling sum for the last 3 months, but adapting this would mean to create lots of helper key figures. Is there a faster way?

Thanks in advanced.

Alex.

[lingaiahvanam · Accepted solution]

Hi Alex,

The simple way is run the statistical forecast model with a simple average or based on your requirement.

Best Regards,

Lingaiah

[alexrajo · Accepted solution]

Thanks Lingaiah, this is the easier way and works correctly. Thanks to both.