Skip to Content
avatar image
Former Member

Rounding

I have a number that is 7 decimal places. I want to format it to two decimal places using standard rounding and display it in a table. Can you help with how to format this?

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 14, 2007 at 03:28 PM

    Kevin,

    you need to apply numeric formatting to the field. go to Properties > Formatting tab>Select number format = Numeric, uncheck 'Local Format' and set decimal places to 2. When it truncates decimal places, it rounds up as well.

    prachi

    Add comment
    10|10000 characters needed characters exceeded