Rounding an Average Number

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top