Division by zero 1

[MICKI0220]

I've looked at a post which said to put an iff function in the calculation this is my original control

=((Sum([standards])-Sum([hours]))/Sum([standards]))

I then added the iff statement before it to make it look like this:
=iif(sum([standards]) = 0,0((Sum([standards])-Sum([hours]))/Sum([standards]))

I save it but then when I click on view it brings the statement back to the original statement and deletes what I just typed in there. Can someone help understand if maybe I have a syntax error or something going on here..

Thank you

Micki

 

[lameid]

It is syntax... you left out a comma after the 0. IIF has three parameters. You also had an extra left parenthesis where I added the comma.

=iif(sum([standards]) = 0,0[red],[/red] (Sum([standards])-Sum([hours]))/Sum([standards]))

 

[MICKI0220]

Thank you very much, that did it.