reporting services - Convert Crystal Reports formula to SSRS expression

Question

IF {Field_A} = 0 THEN 0 ELSE (({Field_B} / {Field_A})*100)

I am trying to convert this formula to an SSRS expression. I have tried many different =IFF statements, but cannot seem to get it to run correctly.

Answer 1

Almost a duplicate question: if you search here for #error ssrs iif you'll get plenty of results, such as Does the iif function compute both paths in SSRS or is it short-circuited?

Rewriting you statement is straightforward then:

=IIF(
   Fields!Field_A.Value = 0,
   0,
   Fields!Field_B.Value /
   IIF( Fields!Field_A.Value = 0, 1, Fields!Field_A.Value) * 100 )