Summing the time dimension

Highlighted
Previous Contributor

Summing the time dimension

Hi, I'm trying to do something which I think should be very simple but which I just can't seem to get working in Anaplan. I have two modules with exactly the same dimensions, except one has a time dimension (years) and the other does not. How can I have a line item from the second module (without the time dimension) reference a line item in the first module so that it equals the sum of the values over time? I've tried setting the summary option for 'summary' and 'time summary' in the blue print of the first module to sum and yet the output always just comes through as zero regardless of the values in the first module. Any help would be hugely appreciated as I'm pulling my hair out over this one!!! Many thanks, Matt

4 REPLIES 4
Highlighted
Group Leader - Employee

RE: Summing the time dimension

Hi Matt, You could use something like the following formula Source module name.Source line item name[SELECT: TIME.'FY13'] This would select the total FY 13 (if that is the required year) from the source module and pull into the target module. Hope this helps
Highlighted
Previous Contributor

RE: Summing the time dimension

Hi Matt, Since your target doesn't have a time dimension, the line item does not know which time period to pick up so you will need to tell it which time dimension you want.  Since you want it to sum all of the time periods, you could do this a few ways.  You could do a select statement for each year.  For example, Source.line item[select: time.'fy12']+ Source.line item[select: time.'fy13']+ Source.line item[select: time.'fy14']. If you have the box checked for "Total of all Periods" in the time section of the Settings tab, your formula would be: Source.line item[select: time.All Periods] Or you can create a YTD line item in the source where the formula is: YTD = Cumulate(Line item).  Then you could link your target module to this line item and select the last year in the module: Source.YTD[select: time.'fy14'] I hope this is helpful! Jill King
Highlighted
Previous Contributor

RE: Summing the time dimension

Thanks very much, that's really useful. It works with 'All Periods' in place of 'FY 13' as well which keeps the formula dynamic. Perfect!
Highlighted
Previous Contributor

RE: Summing the time dimension

Jill, thanks to you as well. That was exactly what I went with.