Round to 4 decimal places

Reply
Highlighted
Blue 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
Blue Belt

Re: Round to 4 decimal places

Doh! (in my best Homer Simpson)

Green Belt

Re: Round to 4 decimal places

Lol!

rahul
Announcements
Win free lodging at Domopalooza! We want to hear your Domo story, enter our Dojo contest and win up to four nights lodging at Domopalooza. Click here!