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

    Calculations based on field's contents


      Hello All,


      I need to create a total based on other fields.



      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