Round to 4 decimal places

swagner Contributor

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?

Best Answer

  • rahul93
    rahul93 Contributor
    Answer ✓

    Did you try ROUND(field,4)?