Customizing numeric displays

Overview

A field for how many decimal places to output is shown when an applicable aggregation method is selected. Additional customization can be added onto each aggregation method.

Content

Using a custom aggregation method with a colon, the following options can be added to customize numeric outputs.

  • 0 prior to the decimal: the number of zeros entered prior to the decimal indicates how many digits to always display. A 0 will be used to fill in spaces as needed.

  • 0 after the decimal: the number of zeros entered after the decimal indicates how many decimal places to always display. A 0 will be used to fill in spaces as needed.

  • # after the decimal: Used to indicate the maximum number of decimal places to display

  • Comma (,) before the decimal: indicates to display a comma as a thousands separator

Example Input

Example Output

Example Input

Example Output

M:000.000

025.200

M:0.00

25.20

M:###.###

25.2

M:#.####

25.2

Sum:0,0.00

5,432.10

Sum:0.00

5432.10

Actions

  1. Open the Design tab of the Data View Update page

  2. Select the variable

  3. Select Custom for the aggregation method

  4. Enter a custom template by entering the aggregation method(s) with each method followed by a colon and the numeric value format

  5. For an existing row in the data view:

    1. Click on the variable name in the right panel

    2. Select Custom for the aggregation method, if not already selected

    3. Enter the custom template

    4. Select Continue