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?
Answers
-
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
0 -
I have tried both Sum and Formula as the summary method but both return 0.0
-
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
David
0
