Method Community

I need help with the expression of a calculated field in a report

I want the field to show 'weekly' unless the name of the work order is Lawn Service (25) and then I want 'Biweekly'

This is what I have, but it won't let me have spaces in the name

Iif([Activity.Comments]=Lawn Service (25),'Biweekly','Weekly')

What am I missing?

Hi Marcelo,

Try putting the work order name in single quotations.

I should also point out that the operator for "equals" is == (double equal sign).

Hope this helps.

- Justin