Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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,
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,