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

 

 

Best Answer

Answers

  • @lcapon 

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

    Check if its correct.

     

    Thanks

    Abhay

  • 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

     

  • 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'))