I have the following statement:

=iif( Fields!Ticket_Budget.Value = 0,0, Fields!Ticket_Sales.Value/Fields!Ticket_Budget.Value)

For some reason, it keeps trying to divide by zero when the budget fields IS equal to zero.

Any suggestions?

This is one of the major PITA's in Reporting Services...

Reporting Services evaluates every part of the if statement so you have to do a nested if that evaluates to 1 if the value of ur field is 0.

Like so...

=iif(Fields!Ticket_Budget.Value=0,0,iif(Fields!Tic ket_Budget.Value=0,1,Fields!Ticket_Sales.Value/Fields!Ticket_Budget.Value))

Try that...

--
Ben Sullins
Sql Developer - Our Vacation Store

Ummm...how does that fix the problem??? You *STILL* end up doing a divide by zero if *ALL* parts of *ALL* IIF's are evaluated.

I think you just made a typo. I think you meant to write:
That way, if the value *IS* zero, you change it to 1 so no "divisiion by zero". But then the prior IIF ends up ignoring the division quotient, anyway, so the divide by 1 has no impact.

You *COULD* also do
So that the quotient becomes a really tiny number and, when displayed, will show as zero. Don't do this if you will use the result in any further calculation, but it should work for display-only purposes.