user3847080 user3847080 - 1 year ago 94
SQL Question

Eliminate #Error within Report Builder 3.0 when dividing by 0

When the following formula divides by 0, all three of the below are returning




=IIf((Sum(Fields!Q1Actuals.Value))=0 Or (Sum(Fields!Q2ActDelta.Value))=0," ",(Sum(Fields!Q2ActDelta.Value))/(Sum(Fields!Q1Actuals.Value)))

What do I need to do to eliminate
? Why isn't report builder following the true condition?


Answer Source

It's caused by the fact that ReportBuilder still tries to evaluate the false path, even if the condition resolves to true. The command below should solve your problem.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download