<div>
<div class="content wysiwyg-content">
What is wrong with this SSRS expression?<br />
<br />
=iif(Sum(Fields!Total.Valu<wbr />e) = &quot;&quot;, &quot;4&quot;, &quot;3&quot;)<br />
<br />
I am getting a lot of 4's but also a lot of errors.
</div>
</div>


What is wrong with this SSRS expression?

=iif(Sum(Fields!Total.Value) = "", "4", "3")

I am getting a lot of 4's but also a lot of errors.

ssrs iif expresssion

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.