Friday, March 23, 2012

Need expression help

Can someone one tell me the correct expression to take a figure like 24.09876 and make it show 24% I have tried using the following expression

=FormatPercent(Avg(Fieilds!avgPercentDiscL)) and I keep getting 2409.876% I need it to show 24% please help asap. Thanks

How about this:

= Convert.tostring(convert.toint(Fieilds!avgPercentDiscL)) & "%"

|||

Hello,

It does not reconize the toint I am using C# vs.net 2005 sql report

|||

Yes its all VB/VB.NET syntax irrespective of what you are using..

try toint16 or toinr32..

|||

try this

= Round(Avg(Fieilds!avgPercentDiscL)),0).ToString() + "%"

Bye

Vaibhav

|||

=FormatPercent(Fieilds!avgPercentDiscL.Value,0)

The second parameter specifies the number of digits after the decimal, in this case none.

No comments:

Post a Comment