/
Customizing numeric displays

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

Related content

How to customize the aggregation method
How to customize the aggregation method
More like this
Errors with custom template for aggregation method
Errors with custom template for aggregation method
More like this
Customize data view column header
Customize data view column header
More like this
Add a Custom Variable Group Layout
Add a Custom Variable Group Layout
More like this
Aggregation Methods
Aggregation Methods
More like this
Examples of outputting numeric variable values
Examples of outputting numeric variable values
More like this