How to calculate Run rate

edited March 11 in Modeling

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.

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.

  • Thanks @ravi