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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.