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
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
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
Hi @naushad786 , I cannot use SELECT function as there will be other parent accounts i have in my hierarchy.
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,
I have created a similar scenario and it is working fine. please have a look below screenshot.
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.
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.
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…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…