sum not working

EliMoein

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.

JMVasicek

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.

Unknown

This content has been removed.

Kanishq17

hi @EliMoein

If source contains time dimension and target does not contain time dimension , so you can get aggregate for the year for your list by using timesum function

in the target use timesum(value) to aggregate from source to target without time

EliMoein

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.