Exclusions

jenmclean — Thu, 05 Dec 2013 17:37:32 GMT

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!

Re: Exclusions

Gysbert_Wassenaar — Thu, 05 Dec 2013 17:42:59 GMT

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

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