I'm attempting to create a function whereby it will return the line item value of it's parent without using SELECT.
I have a target module with Machines List (Top level All Machines), a source module with Machines list and a system module with the Machines list & a line item returning the Parent of that list item (All Machines)
Unfortunately when I reference the Target module from the source module using LOOKUP (referencing System module) it returns 0 but will work if I use a SELECT statement & select 'All Machines'
Is there a way to return the parent value without using SELECT?
Hi Mark, As far as I can see from your screenshots the dimensionality of the target and the source are the same. You only need to use aggregation formulas like LOOKUP if you need to bridge dimensions where there are differences in the dimensionality of the target and source modules. As this is not the case I did not include them in my solution.
Chris Heathcote Bedford Consulting
Gold Partner and Regional Partner of the Year 2021, EMEA
Apologies but still very confused. You are saying to reference the top item of a list (being All Machines in this case)? This go's against my understanding of Anaplan whereby you reference Line Items. If the module had more than 1 line item how would Anaplan know which line item was being referenced?