SUM and IIF statements are not giving results in Text Values
<p>I am creating a report using Report Builder 3.0 SQL Server 2008 R2. One Form there is a check box, when checked it save Yes in view/table and if not checked it save No in view/table. When Checked, I need to print a text statement on report and if not checked then I need to print another field's value. If I use the following expression:</p>

<pre><code>=SUM(IIF(Fields!CheckekBox_Checked.Value="Yes", 1,0) ,"DataSet1")
</code></pre>

<p>it prints 1, when checked and print 0 when not checked. Works fine.
but when I use the following expression:</p>

<pre><code>=SUM(IIF(Fields!CheckekBox_Checked.Value="Yes", "CHECKBOX is CHECKED", Fields!Address.Value) ,"DataSet1")
</code></pre>

<p>It didn't print anything but <code>#Error</code> (as text) on report. There is no error while saving the report. Can you please help me to correct the syntax?</p>