Parent and Ratio

Hi, I need a ratio along a list called 'P&L' I made 2 line items :

MyRef = PARENT(ITEM('P&L'))
ratio = Budget N/ Budget N[LOOKUP: MyRef]

MyRef give the real parent of the P&L list. Everythings seems OK here. Ratio give zero (!) which is wrong by the way the forumula Budget N[LOOKUP: MyRef] gives 0 also How can i bring the value of the parent to calculate my ratio ? Best regards, Yls

Accepted answers

elizabeth_schaf

Is this a composite hierarchy? Or a hierarchy in one list?
If you have a hierarchy in one list, then the look up will not work.

All comments

elizabeth_schaf

There are several reasons this may not be pulling the right number for you. Did you already check your dimensions?

elizabeth_schaf

Is this a composite hierarchy? Or a hierarchy in one list?
If you have a hierarchy in one list, then the look up will not work.

aimanfikri

Hi. Does anyone know the solution for the question? I was struggling with the same issue.

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
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.…