Hi,
I have a field with dataqtype INT. I need to avg this field value and show in decimal with two points, which convert function do I use?
Thanks in advance!
Printable View
Hi,
I have a field with dataqtype INT. I need to avg this field value and show in decimal with two points, which convert function do I use?
Thanks in advance!
Should change to decimal data type.
Use Cast or Convert to pretend that it's a differnet datatype.
Select Avg(Cast(FieldName as decimal(9, 2)))
Thanks, that worked.