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.