Line Item Subset Lookup

[neg177]

Hi,

Trying to look up a Line Item Subset to use in a formula. Example of the formula is as follows.

IFITEM(LISS C67 Commissions)='LISS C67 Commissions'.'52053 - Internal DS rep commission'THEN'R18 Lending Summary'.$ Funded/'R18 Lending Summary'.'Total Cash Collections*'ELSE0

Formula is not going through because using a LISS.

[andrewtye · Accepted solution]

Have you had a read ofthis? Should have the answer you need... failing that have you tried a simple lookup module with line-items formatted against the LISS and doing it that way.