Calculate MOVINGSUM from module with no time to module with time

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

source_module_LI_132023.PNG

target_module_LI_132023.PNG

Accepted answers

All comments

KirillKuznetsov

@mmckenzie

I would suggest to use timesum formula as for start and end you can select time period as arguments.

Then you need to calculate Start month with the following formula: 'TEST - CURRENT MONTH' - Month Number

And the final formula should look like this:

TIMESUM(source module line item, Start month , 'TEST - CURRENT MONTH' , SUM)

mmckenzie

@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

KirillKuznetsov

@mmckenzie

Please send blueprint an other screenshots you think can help us to resolve this.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…