IIF then Else in SSRS

Question

If isnull(field1)

or isnull(field2) then

0

else

ToNumber((field1 / field2) * 100)

==========

how can i rewrite it in the Field Expression in SSRS? Please assist me

Answer 1

 In Reporting Services paginated reports, expressions are generally used to control content and report appearance. 

 IIF is a decision function that returns one of two values depending on whether the expression is true or not.

I hope this would help you:

=IIf(IsNothing(Fields!field1.Value)Or IsNothing(Fields!field2.Value) ,0,((Fields!field1.Value)/(Fields!field2.Value)*100))

Check out SSRS Certification Training  from Intellipaat to master the concepts of SQL Server Reporting Services