Checking for zero before operation 1

[wdverner]

Hi All
Quick Question

I have this calculation Per: [SM]/[TW]

What i want to do is before i do this, check if TW is zero- if it is then Perf=0 else carry out the operation..


Whats my best way of achieving this?

Many Thanks to all.

 

[PHV]

Per: IIf(Nz([TW],0)=0,0,[SM]/[TW])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wdverner]

the legend that is PHV.