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 |
---|---|
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
Open the Design tab of the Data View Update page
Select the variable
Select Custom for the aggregation method
Enter a custom template by entering the aggregation method(s) with each method followed by a colon and the numeric value format
For an existing row in the data view:
Click on the variable name in the right panel
Select Custom for the aggregation method, if not already selected
Enter the custom template
Select Continue