1 2 Previous Next 17 Replies Latest reply on May 8, 2017 4:10 PM by howardh

    Calculations based on field's contents

    macfiles

      Hello All,

       

      I need to create a total based on other fields.

       

      Ex.

      If Field "Serviced By" = John Smith

      then Multiply Field "hours worked" *150

      Else Field "Serviced By" = "(anyone else) "

      then Multiply Field "hours worked" *125

       

       

      I thought it would be as simple as

      If(Invoices::Serviced By =”John Smith”;Invoices::TotalHours * 150)

       

      Each time it's saying that an operator is expected.

        1 2 Previous Next