sum not working
I'm stuck while building a module in Anaplan. In one module, I have numbers associated with the months of the year 2024, and the module has Anaplan's time scale dimension. In this module, I have a line item formatted as a list that contains four members. Each number is assigned to one of these four list members.
In another module, I only have this four-member list as a dimension without the time dimension. I want to sum the numbers corresponding to each of the four list members in this module. However, because there’s no time dimension in this module, I cannot use the SUM
function. I also tried using a fake time dimension, but that didn’t work either.
Answers
-
Hi @EliMoein, unfortunately you're correct and you can't SUM over time.
Is the time summary of "All Periods" enabled in your model? If so, you could enable a Sum time summary method on the line item you want to sum, then select all periods in your target module.
If not, you'd need to use the TIMESUM function in the module without time. It's preferable to use All Periods if possible due to the performance difference between the two methods.
In either scenario, there's a chance you would need to use a staging module with the 4-member list and time before you aggregate to non-time.
0 -
Thank you all, it worked with the TIMESUM function. It will also work if we use the SELECT function and check the box (Time) total of periods.
0