How to calculate Run rate

Monpero

Hi All

What is the best way to calculate a 12 month run-rate formula in Anaplan.

Below is the calculation I used but am not getting the right figure. Also 0 used MOVIMSUM(Actuals, -12, -1, AVERAGE) but not getting the right figure

Your input will be really helpful. Thanks.

Runrate.xlsx

In this calculation module I referenced the Version x Time module

ravi

Hi There,

Based on your excel file here is my implementation. Essentially MOVINGSUM will work. Please let me know if this works for you.

Monpero

Thanks @ravi