Line Item Subset Lookup

neg177
Regular Contributor

Line Item Subset Lookup

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
andrewtye
Master Anaplanner/Community Boss

Re: Line Item Subset Lookup

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.

View solution in original post

1 REPLY 1
andrewtye
Master Anaplanner/Community Boss

Re: Line Item Subset Lookup

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.

View solution in original post