Exclusions

[jenmclean]

What is the best way to write the following:

Sum(If(INV|DetTypeID = '4' and Match(KEY|ProductNumber = 'WARRANTY'),INV|InvoiceAmount)) as GR|Labor, //Labor

If DetailType = 4 then exclude product  number "warranty", include invoice amount and save as gross labor.

Thanks in advance!

[Gysbert_Wassenaar · Accepted solution]

Sum(If(INV|DetTypeID = '4' and not Match(KEY|ProductNumber = 'WARRANTY'),INV|InvoiceAmount)) as GR|Labor,

or

Sum(If(INV|DetTypeID = '4' and KEY|ProductNumber <> 'WARRANTY',INV|InvoiceAmount)) as GR|Labor,