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?
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
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