Getting 0 results from a COLLECT line item

jspascual

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!

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.