nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Get Total Value on another Line Item

tompatrick.ting

Hi,

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.

Thanks in advance,

Tom

Accepted answers

jasonblinn

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.

https://community.anaplan.com/t5/Anaplan-Platform/Alternative-to-LOOKUP-with-non-composite-hierarchies/m-p/59573#M10630

Jason

All comments

naushad786

Hi @tompatrick.ting ,

In this case you can try to use [Select: UP A -P] function instead of Look up to get the total value.

Thanks,

Naushad

tompatrick.ting

Hi @naushad786 , I cannot use SELECT function as there will be other parent accounts i have in my hierarchy.

anirudh

Hi Tom,

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]

Regards,
Anirudh

tompatrick.ting

Hi @anirudh , this is the exact formula i currently use in my module. The line item only shows zero instead of the total amount.

Regards,

Tom

naushad786

Hi @tompatrick.ting ,

I have created a similar scenario and it is working fine. please have a look below screenshot.

Thanks,

Naushad

tompatrick.ting

Hi @naushad786 , I tried to create a new module to check but still no luck. Please help check why its not calculating properly in my module.

Regards,

Tom

jasonblinn

https://community.anaplan.com/t5/Anaplan-Platform/Alternative-to-LOOKUP-with-non-composite-hierarchies/m-p/59573#M10630

Jason

ChrisAHeathcote

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.

ChrisAHeathcote

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.

gsmerilli

Thanks for this example it help me a lot with a similar issue!!

Quick Links

Can you help?

Unanswered questions

How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…