Hi,
I have a table with avg summaries. When the type column is int32, the avg value is int, the last two decimal places are always .00.
I try to set the format {0:#0.00} but the avg value is still int.
There is a way to get a float or double value for avg function with an int32 column?
thank you very much.
I have a table with avg summaries. When the type column is int32, the avg value is int, the last two decimal places are always .00.
I try to set the format {0:#0.00} but the avg value is still int.
There is a way to get a float or double value for avg function with an int32 column?
thank you very much.
2 Answers, 1 is accepted
0
Hi Andrea,
Steve
the Telerik team
Similar to Transact-SQL, when the argument of the function is an integer, the returned type is an integer. If you need the exact (floating point) result, you should cast the argument to floating point using the built-in CDbl() function.
Regards,Steve
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items
0
andrea
Top achievements
Rank 1
Rank 1
answered on 22 Apr 2011, 12:40 PM
Ok, it work,
thank you Steve!
thank you Steve!