Calculation Query

lcapon
Frequent Contributor

Calculation Query

HI. I'm struggling to understand why I am getting a zero answer on my pension row. Please see June 21 as an example.

lcapon_1-1623241773689.png

 

 

lcapon_0-1623241744857.png

lcapon_0-1623242332837.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
lcapon
Frequent Contributor

Re: Calculation Query

Excellent! Thank you so much for that!

View solution in original post

4 REPLIES 4
abhay.kanik
Regular Contributor

Re: Calculation Query

@lcapon 

Initial Thoughts, Your parent line item is blank in image which you are using for lookup.

Check if its correct.

 

Thanks

Abhay

lcapon
Frequent Contributor

Re: Calculation Query

Ah thank you! I've been struggling to poplulate that line, this would make sense. Please see error message I get:

lcapon_0-1623242149282.png

lcapon_1-1623242204875.png

 

kavinkumar
Certified Master Anaplanner

Re: Calculation Query

HI @lcapon,

Your formula is correct but slight modification in the syntax. Add '' whenever you have special characters coming in. So your formula should be Parent(item('ES005 Employee Details'))

Regards,
Kavin.
lcapon
Frequent Contributor

Re: Calculation Query

Excellent! Thank you so much for that!

View solution in original post