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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top