Need help with 1.5.7.2 Add Formula to SYS13 Line Item

krishnadbr
Contributor

Need help with 1.5.7.2 Add Formula to SYS13 Line Item

Hi All,

 

I am struck at this point. I have followed the notes carefully

Add the formula for the Has Data? line item in the SYS13 Account SKU Filter module.

Considerations for the formula: 

  • How could you sum the data over all time periods? 
  • All Periods is not an aggregation method at the model-level timescale. 
  • The formula should check the total of all product SKU volumes over all time periods to determine if the value is not equal to zero.

And tried to apply the below formula.

TIMESUM(IF 'DAT03 Historic Volumes'. Volumes<>0, THEN 'DAT03 Historic Volumes'. Volumes ELSE 0)

 

Is the syntax of TIMESUM correct, And source correct. I first tried checking Boolean from SYS13 Has Data? itself but it did not work. And then I tried DAT03 as source. But still I am getting an error. 

 

I got the following error.

krishnadbr_0-1633529296077.png

 

 

Please can you guide me on this. 

 

Thanks,
Balarama Krishna.

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Akhtar.shahbaz
Community Boss

Re: Need help with 1.5.7.2 Add Formula to SYS13 Line Item

Hi @krishnadbr ,

 

You don't have to use if condition in TIMESUM formula, you can write a formula as TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0.

for more detail about Timesum syntax, Please refer below link

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

 

Thanks

Akhtar

View solution in original post

1 REPLY 1
Akhtar.shahbaz
Community Boss

Re: Need help with 1.5.7.2 Add Formula to SYS13 Line Item

Hi @krishnadbr ,

 

You don't have to use if condition in TIMESUM formula, you can write a formula as TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0.

for more detail about Timesum syntax, Please refer below link

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

 

Thanks

Akhtar

View solution in original post