<div>
Depends on the layout of you matrix. But shouldn't the formula be:<br />

<pre><code id="code-20-37729313-1">=IIF(LTRIM(RTRIM(Fields!USERDEF1.Value)) &lt;&gt; (&quot;OTHER&quot;)
AND (LTRIM(RTRIM(Fields!USERDEF1.Value)) &lt;&gt; &quot;KEY ACCOUNT&quot; AND SUM(Fields!ID0_3_MTHS.Value) &gt;0 )
, SUM(Fields!ID0_3_MTHS.Value) ,Fields!NoinGroup.Value)</code></pre>
Now you're only showing the sum if it's &lt;= 0. I you need further help please provide a small sample of your data, the layout of your matrix, the desired result and the version of SQL Server.
</div>


Depends on the layout of you matrix. But shouldn't the formula be:


=IIF(LTRIM(RTRIM(Fields!USERDEF1.Value)) <> ("OTHER")
AND (LTRIM(RTRIM(Fields!USERDEF1.Value)) <> "KEY ACCOUNT" AND SUM(Fields!ID0_3_MTHS.Value) >0 )
, SUM(Fields!ID0_3_MTHS.Value) ,Fields!NoinGroup.Value)

Now you're only showing the sum if it's <= 0. I you need further help please provide a small sample of your data, the layout of your matrix, the desired result and the version of SQL Server.

<div>
<div class="content wysiwyg-content">
Does anyone know why this IIF statement only evaluates once when it is in a Matrix but works ok outside the matrix ?<br />
<br />
=IIF(LTRIM(RTRIM(Fields!US<wbr />ERDEF1.Val<wbr />ue)) &lt;&gt;&nbsp;(&quot;OTHER&quot;)<br />
AND (LTRIM(RTRIM(Fields!USERDE<wbr />F1.Value))<wbr /> &lt;&gt;&nbsp;&quot;KEY ACCOUNT&quot; AND SUM(Fields!ID0_3_MTHS.Valu<wbr />e) &gt;0 )<br />
&nbsp;,Fields!NoinGroup.Value, SUM(Fields!ID0_3_MTHS.Valu<wbr />e))
</div>
</div>


Does anyone know why this IIF statement only evaluates once when it is in a Matrix but works ok outside the matrix ?

=IIF(LTRIM(RTRIM(Fields!USERDEF1.Value)) <> ("OTHER")
AND (LTRIM(RTRIM(Fields!USERDEF1.Value)) <> "KEY ACCOUNT" AND SUM(Fields!ID0_3_MTHS.Value) >0 )
 ,Fields!NoinGroup.Value, SUM(Fields!ID0_3_MTHS.Value))

Evaluate iif in a MAtrix

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.