Calculation Query

[lcapon]

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

[abhay.kanik]

@lcapon

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

Check if its correct.

Thanks

Abhay

[lcapon]

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

[kavinkumar]

嗨@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'))

[lcapon · Accepted solution]

Excellent! Thank you so much for that!