1 Reply Latest reply: Dec 5, 2013 12:44 PM by Gysbert Wassenaar RSS

    Exclusions

    Jennie Elliott

      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!