Round to 4 decimal places

Reply
Highlighted
Purple Belt

Round to 4 decimal places

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?


Accepted Solutions
Green Belt

Re: Round to 4 decimal places

Did you try ROUND(field,4)?

rahul

All Replies
Green Belt

Re: Round to 4 decimal places

Did you try ROUND(field,4)?

rahul
Purple Belt

Re: Round to 4 decimal places

Doh! (in my best Homer Simpson)

Green Belt

Re: Round to 4 decimal places

Lol!

rahul
Announcements
New to Dojo Please update your Dojo handle and personal settings. Click here!