Round to 4 decimal places

swagner

Via beast mode or magic ETL I need to round to 4 decimal places so I can group prices charged to customers.  Building reporting to identify which is the most frequently charged value.  Need to group the pricing events so they match to 4 decimal places.  I see the ROUND( function, but that appears to round to nearest whole number.  Is there another way, or am I misunderstanding?

rahul93

Did you try ROUND(field,4)?

swagner

Doh! (in my best Homer Simpson)

rahul93

Lol!