How to sum time ranges

hyudolee
Occasional Contributor

How to sum time ranges

I have a problem when aggregating lineitem by time .

 

I want to aggregate Amount by "Aggregate Lineitem" (From Jan-21 To Mar-21).

The Module A&B has set by time range, so we can't do it.

 

Table A ( Time Range : past 2years)

ListMonthJan-21Feb-21Mar-21Apr-21May-21
LineitemAmount A100200300400500
 Aggregate  
 Amount B10020030000

 

Table B (No Applies To) 

ListNone 
LineitemAmount600

 

 

Please give me a solution.

3 REPLIES 3
Misbah
Moderator

Re: How to sum time ranges

@hyudolee 

 

Use TIMESUM function.

 

 

Misbah

AWhitworth
Certified Master Anaplanner

Re: How to sum time ranges

I agree Timesum is your best bet for this as it is very flexible, you can either timesum over the whole time range in which case your formula would just be Timesum(Table A.Amount B) or you can specify the start and end dates after the Amount B. Here is a link to the Anapedis page which shows all the different options available to you: 

 

https://help.anaplan.com/en/13d8b551-4e13-413b-a39f-f25579d21e38 

hyudolee
Occasional Contributor

Re: How to sum time ranges

Hi, AWhitworth & Misbah.
 

Thanks for replay.

I understand!