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:
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.
Please can you guide me on this.
Thanks,
Balarama Krishna.
Solved!去解决方案。
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
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
Hi
I followed this formula (I had been making it too complicated). My line items are not returning any values and are not showing as Booleans.
Any suggestions?!
Thanks
Emma