HI. I'm struggling to understand why I am getting a zero answer on my pension row. Please see June 21 as an example.
Excellent! Thank you so much for that!
Initial Thoughts, Your parent line item is blank in image which you are using for lookup.
Check if its correct.
Ah thank you! I've been struggling to poplulate that line, this would make sense. Please see error message I get:
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'))