How to calculate Run rate

Options
Monpero
Monpero
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.

Runrate.xlsx

In this calculation module I referenced the Version x Time module

Answers

  • ravi
    ravi
    Options

    Hi There,

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

    image.png

  • Monpero
    Monpero
    Options

    Thanks @ravi

Categories