multiiple iif statements in a report query

Joined
Aug 26, 2010
Messages
1
Reaction score
0
Hi,

I can't seem to get the following multiple iif statement to work

=IIf([Loss Budget]="One Offs","n/a",IIf([Loss_Budget]=0,0,([Losses]/[Loss_Budget])))

Where am I going wrong?

Thanks
 
Last edited:
Back
Top