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.
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
Thanks for replay.
I understand!
is there a way to use timesum independently from the current period of the model
Please review this information where it talks specifically about timesum(). Basically, you set the dates, start and end dates for the function to use. Also, please do not use timesum() on line item where Time is in the Applies To, instead think about using MovingSum().
https://help.anaplan.com/45c3bc48-4d80-490d-9b18-76af505c6907-TIMESUM
Rob