How to sum time ranges

[hyudolee]

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)

List	Month	Jan-21	Feb-21	Mar-21	Apr-21	May-21
Lineitem	Amount A	100	200	300	400	500
	Aggregate	✔	✔	✔
	Amount B	100	200	300	0	0

Table B (No Applies To) 

List	None
Lineitem	Amount	600

Please give me a solution.

[Misbah]

@hyudolee 

Use TIMESUM function.

Misbah

[AWhitworth]

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]

Hi, AWhitworth & Misbah.

Thanks for replay.

I understand!