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.

 

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.

Outcomes