Level 2 Sprint 1 - 1.5.7.2 Add Formula to SYS13 Line Item

Highlighted
New Contributor

Level 2 Sprint 1 - 1.5.7.2 Add Formula to SYS13 Line Item

Hi,

 

Can I please get some help with the formula for this?

 

Thanks

2 REPLIES 2
Highlighted
Contributor

Re: Level 2 Sprint 1 - 1.5.7.2 Add Formula to SYS13 Line Item

1)The formula should check the total of all product SKU volumes over all time periods 

2) check if the value is not equal to zero. 

 

1) You need to use Timesum() function to sum Product SKU volumes over all time periods, Review timesum() function  :  https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/TIMESUM.html 

2) and the result you achieved using that function need to compare using a conditional operator to set boolean value true.

Review conditional operator:

https://help.anaplan.com/anapedia/Content/Calculation_Functions/Operators.html

 

 

Highlighted
New Contributor

Re: Level 2 Sprint 1 - 1.5.7.2 Add Formula to SYS13 Line Item

Thanks very much.