Rounding an Average Number

  • Thread starter Thread starter Berny
  • Start date Start date
B

Berny

Can anyone tell me if or how I can do the following.

I am using the Group and Average functions in a view that returns a result
that looks like 19.25900

How can I make this number stop or round too 1 digit after the decimal
place?

below if the expression I'm using:

(AVG(dbo.WORK_ORDER_EVENT.EVENT_LABOR_HOURS) > 0)

Any help is greatly appreciated.
 
Back
Top