<div>
I have this expression that does not work how I want it to work:<br />
<br />
CASE <br />
&nbsp; &nbsp; WHEN (SUM(FavUnfavCostChange) &lt;&nbsp;(2/100) THEN 'Less'<br />
&nbsp; &nbsp; WHEN SUM(FavUnfavCostChange) &gt;&nbsp;(2/100) THEN 'More'<br />
&nbsp; &nbsp; ELSE NULL<br />
END AS 'Flag'<br />
<br />
But I get:<br />
<br />
0.00000815000000000000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;More &nbsp; &nbsp;-- this is not more than 2 cents, is just a positive number<br />
-0.00094700000000000000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Less &nbsp; &nbsp; -- this is not less than 2 cents, is just negative number<br />
-0.00222000000000000000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Less &nbsp; &nbsp; -- this is not less than 2 cents, is just negative number<br />
-0.00012250000000000000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Less &nbsp; &nbsp; -- this is not less than 2 cents, is just negative number<br />
0.00000000000000000000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NULL &nbsp; &nbsp;-- this is zero so null is fine<br />
0.01188576000000000000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;More &nbsp; &nbsp;-- this is not more than 2 cents, is just a positive number
</div>


I have this expression that does not work how I want it to work:

CASE
    WHEN (SUM(FavUnfavCostChange) < (2/100) THEN 'Less'
    WHEN SUM(FavUnfavCostChange) > (2/100) THEN 'More'
    ELSE NULL
END AS 'Flag'

But I get:

0.00000815000000000000            More    -- this is not more than 2 cents, is just a positive number
-0.00094700000000000000            Less     -- this is not less than 2 cents, is just negative number
-0.00222000000000000000            Less     -- this is not less than 2 cents, is just negative number
-0.00012250000000000000            Less     -- this is not less than 2 cents, is just negative number
0.00000000000000000000            NULL    -- this is zero so null is fine
0.01188576000000000000            More    -- this is not more than 2 cents, is just a positive number

<div>
<div class="content wysiwyg-content">
I have a report with a column numeric name: <b>cost change</b>. <br />
<br />
I would like to highlight and turn the font to bold in some cells when the value in cell <b>cost change</b> fluctuates +/- 2 cents.<br />
<br />
Is there any chance someone can show me how the IIF would need to be coded?<br />
<br />
Thank you.
</div>
</div>


I have a report with a column numeric name: cost change. 

I would like to highlight and turn the font to bold in some cells when the value in cell cost change fluctuates +/- 2 cents.

Is there any chance someone can show me how the IIF would need to be coded?

Thank you.

highlight, turn bold field based on condition in another field

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.