AnsweredAssumed Answered

Calculations based on field's contents

Question asked by macfiles on Apr 26, 2017
Latest reply on May 8, 2017 by howardh

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.