Lookup on Line item subset "Parent"

Highlighted
Certified Master Anaplanner

Lookup on Line item subset "Parent"

Hi,

 

I have a collect() module dimensioned by a line item subset and time and another by account and time, the account module is referencing the collect module using a lookup based on a mapping. 

 

The mapping dropdown allows me to select any member in the LISS and the formula works if I pick the first member i.e. Rent, however selecting a LISS member such as total turnover returns 0 as total turnover is a summary of rent and other line items in the original source module. 

 

Does anyone know a workaround for this to enable a lookup against any member in the line item subset? 

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Lookup on Line item subset "Parent"

@AWhitworth ,

 

On the collect() line item, what is the summary?  If it is set to none, you will not get aggregated data.

 

Hope this helps,

 

Rob

Highlighted
Certified Master Anaplanner

Re: Lookup on Line item subset "Parent"

I have tried both Sum and Formula as the summary method but both return 0.
Highlighted
Master Anaplanner/Community Boss

Re: Lookup on Line item subset "Parent"

@AWhitworth 

I think this is the same issue as using a lookup on a ragged hierarchy (non composite) list.  Lookup resolves but doesn't work

To return the "parent" value, the only way (without using a SELECT), is to create a dummy list of parents, map the children to that using SUM and then LOOKUP back into the target module

 

I've explained it here

https://community.anaplan.com/t5/Best-Practices/Production-lists-and-ragged-hierarchies-logic/ta-p/3...

 

David