<div>
Expressions in SSRS are case sensitive.. you might want to change it to below<br />
<br />
iif(Fields!PercentFlag.Val<wbr />ue =&quot;H&quot;,Format(Fields!Time.Va<wbr />lue, &quot;HH:MM&quot;)<br />
<br />
Please check the percentage flag value ..if it's returning &quot;H&quot; for sure or not<br />
<br />
also if the above exp does not wrk then try interchanging expression value for Y by replacing it with exp for H and H with Y and see the output
</div>


<div>
thanks for your help guys, i'll have &nbsp;alook today.
</div>


<div>
thanks for the help, but did not resolve the issue.
</div>


<div>
<div class="content wysiwyg-content">
i've got a report that contains a group total. <br />
i have a percentflag - H = time. Y = precent. N = number.<br />
<br />
=iif(fields!PercentFlag.Va<wbr />lue =&quot;H&quot;,format(fields!Time.Va<wbr />lue, &quot;HH:mm&quot;),Iif(((Fields!Perc<wbr />entFlag.Va<wbr />lue =&quot;Y&quot;) AND (Fields!Value.Value &gt;0)),Format(Sum(Fields!Val<wbr />ue.Value *100), &quot;0.0&quot;) &nbsp;&amp; &quot;%&quot;, <br />
Iif(((Fields!PercentFlag.V<wbr />alue =&quot;Y&quot;) AND (Fields!Value.Value &lt;0)),Format(Sum(Fields!Val<wbr />ue.Value *100), &quot;0.0&quot;) &nbsp;&amp; &quot;%&quot;, <br />
Replace(cStr(Sum(Fields!Va<wbr />lue.Value)<wbr />),&quot;.0&quot;,&quot;&quot;)<wbr />)))<br />
<br />
the problem is my totals are not correct.<br />
<br />
they are being displayed as.<br />
N = ok<br />
Y = 0274433<br />
H = nothing being displayed.
</div>
</div>


i've got a report that contains a group total. 
i have a percentflag - H = time. Y = precent. N = number.

=iif(fields!PercentFlag.Value ="H",format(fields!Time.Value, "HH:mm"),Iif(((Fields!PercentFlag.Value ="Y") AND (Fields!Value.Value >0)),Format(Sum(Fields!Value.Value *100), "0.0")  & "%", 
Iif(((Fields!PercentFlag.Value ="Y") AND (Fields!Value.Value <0)),Format(Sum(Fields!Value.Value *100), "0.0")  & "%", 
Replace(cStr(Sum(Fields!Value.Value)),".0",""))))

the problem is my totals are not correct.

they are being displayed as.
N = ok
Y = 0274433
H = nothing being displayed.

SSRS Expression

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.