What is the difference between Time sum and Moving SUm

143kishornaidu

I want to know what is the difference between Time sum and moving sum.

Scenarios that we use them individually

Accepted answers

All comments

ArnabG

Hi @143kishornaidu ,

Timesum : It is being used to summing up data for certain period of time for example you need a sum of data from particularly March to June then you can use Timesum to aggregate that. Secondly it is also used to aggregate data from a time dimension module to a without time dimension module.

Movingsum : It is a forecasting method based on aggregation of last few months. It can only be used in the modules with Time dimension.

Hope this helped!

Thanks,

Arnab

M.Kierepka

Hi @143kishornaidu,

MOVINGSUM: for obtaining a time range of data directly relative to the target period. Both source and target should have the same time dimensions. You specify the range using the relative number of periods. Very useful for calculating rolling sums, averages, maxes and mins, or checking if in the last/next few months there is ANY/ALL condition true (on booleans), or some text value is present. So when you need the answer/result in every period of your report/output.
TIMESUM: for obtaining a time range of data not directly relative to the target period. Should really only be used when the target module is not using the same time dimension as the source (or no time dimension at all). You can specify the range using the relative number of periods or exact date/period. It's really useful when you have some module without time (or on higher level) where you need to calculate something based on absolute start and end, like when user selects from when to when they want to calculate something and report doesn't need to have time dimension.

So technically everything that MOVINGSUM does, can be done by TIMESUM, but the problem is, TIMESUM has worse performance. If you have some time, you can check this lighthearted 10-minute video about strengths and differences between these two functions: https://www.youtube.com/watch?v=PvimWuX5jVw

Quick Links

Can you help?

Unanswered questions

one or multiple models
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…