IIF Formula issue

[cfobare79]

I'm trying to write a formula that references a text box [ServiceName] so that if it equals Office & Mobile Employees that it will then reference text box [SumOfQuantity] and multiply it by .104. If the wording in text box [ServiceName does not match I want it to return 0. Below is the fromule I was trying to make work but it's not accepting it.



IIF (([ServiceName] = "Office & Mobile Employees"), ([SumOfQuantity] * (.104), 0)

Every time I try to save it, it is changed to [IIF ((ServiceName] = "Office & Mobile Employees"), ([SumOfQuantity * (].[104), 0)]. Please help

[pbaldy]

You've got an extra parentheses in there. Try

IIF ([ServiceName] = "Office & Mobile Employees", [SumOfQuantity] * .104, 0)

[cfobare79]

For some reason when I save the Report it changes the formula to this [IIF (ServiceName] = "Office & Mobile Employees", [SumOfQuantity * ].[104, 0)]

[pbaldy]

In a textbox you'd need an = at the beginning.

[cfobare79]

lol.... much better... its the simple things