Round to 4 decimal places

Reply
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)

Highlighted
Green Belt

Re: Round to 4 decimal places

Lol!

rahul
Announcements
Call for Presenters! We want to hear your Domo story, submit your entry and win a free pass to Domopalooza 2019!. Click here!