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.