Please help how can I get the total value of another line item to the other. Pls see attached screenshot where I tried to use lookup of the parent hierarchy to get the total value but it is not picking the correct value.
1. Create a line item called Parent and formatted by the parent list in the screenshot; ie. the list containing UP-AP 2. Formula is PARENT(ITEM(<Child list name>)) 3. Formula for CALC3.0 Lease Out is: GLA[LOOKUP: Parent]
You are not able to use PARENT as the summary item is not a child of the summary as they are part of the same list. You can only use PARENT where you have a composite hierarchy consisting of two separate lists.
Chris Heathcote Bedford Consulting
Gold Partner and Regional Partner of the Year 2021, EMEA
Seems like you are using a single level hierarchy as opposed to a composite hierarchy. The best and most scalable solution is to use a composite hierarchy. There are a couple of ideas of how to solve it using a single list like you seem to have in the following thread.