Calculate MOVINGSUM from module with no time to module with time

Options
mmckenzie
mmckenzie Member, ALL USERS, Partner Posts: 2 New Contributor
in Planning & Modeling

Hi there,

 

I need to reference a source module line item with time to a target module line item without time to achieve an Actuals Rolling [6, 12, 28, 24 months] SUM using MOVINGSUM.

 

In this case, it would be the sum of the previous 6 months from Jan 22. 

 

Please see attached screenshots and let me know if I can provide any additional detail. Any insight is greatly appreciated!

 

Thanks!

Mike

Tagged:

Comments

  • mmckenzie
    mmckenzie Member, ALL USERS, Partner Posts: 2 New Contributor

    @KirillKuznetsov 

     

    Thanks for the quick response, this will work for the stagnant TIMESUM but when the current period switches to Feb 22, the SUM will not move according to month number. Any way to incorporate a mapping module?

     

    Thanks ahead of time,

    Mike

     

     

Categories