Line Item Subset Lookup

neg177
neg177
in Modeling

Hi,

 

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

 

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

 

Formula is not going through because using a LISS. 

Tagged:

Best Answer

  • andrewtye
    andrewtye
    Answer ✓

    Have you had a read of this? 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.

Categories