Getting 0 results from a COLLECT line item

jspascual
jspascual
edited March 4 in Modeling

Hello,

I have a line item that has a COLLECT() formula. This returns the values just fine. But when I use this line item and Lookup or Select a specific member, it doesn't return any value. Is there a way to do this, or am I doing it incorrectly?

LINE ITEM

FORMULA

APPLIES TO

SUMMARY

TIME

Source line item

COLLECT()

List 1 & 2, List A&B, LISS: Line Item I want

Sum, Time: Sum

Monthly

Target line item

Source line item[SELECT: 'List 1 &2".1]

I tried to use a Lookup here but no data were returned either

List A&B

Sum, Time: Sum

Monthly

Thanks a lot in advance!

Tagged:

Answers

  • devrathahuja
    devrathahuja

    Hi @jspascual ,
    You need the LISS in the applies to for the target line item too to fetch the value in this case or a select/lookup for the LISS member.

Categories