could someone help me with the formula here 1.5.7.2 Add Formula to SYS13 Line Item

omarismailcch1

this is what is required

Tiffany.Rice

I would recommend reviewing the time and date functions, https://help.anaplan.com/all-functions-160769b0-de37-4f08-87a0-cc3aa55525a3 , you are looking for a function which will allow to aggregate data between time periods. Once you understand that function, its a matter of defining the logical parameters to determine if that aggregated value is not equal to zero.

The following post may also give you some helpful hints:

https://community.anaplan.com/discussion/132937/how-to-get-all-periods-totals-with-tiem-dimenson-in-to-a-target-module-without-time-dimeson