Format Rules for Calculations Returning Number Data Types

When you create a calculation that returns a number, the formatting of the resulting column is based on

• the calculation operation

• the format of the parent column or columns

• the number of decimals specified when a value is typed in the Number box

Note: All non-numeric format elements are ignored when creating the calculation format.