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.
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.
Hi, Try creating a flat module where you can assign list formatted line items to feed your lookup functions. In this module do not include any dimensions, create a line item and format as the target list. Then select the relevant list item. Use this to feed you LOOKUP in the target line item.