Lookup on Line item subset "Parent"

[AWhitworth]

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? 

[rob_marshall]

@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

[AWhitworth]

I have tried both Sum and Formula as the summary method but both return 0.

[DavidSmith]

@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