Format Numbers

Overview

You can customize the format of the facts, metrics, and attributes you add to the Metrics section in your insights. For example, you can round numbers, shorten large numbers, display fixed number of zeros, display currency symbols, add colors, and so on.

For every item in your Metrics section, you can configure your own custom format using specific syntax or select from a variety of predefined formats .

Regional settings

Your regional settings define how the decimal point and the thousands separator are displayed in your insights.

For details about regional settings, see Set Default Number Format for Your User Account.

Define custom number formats

The custom number format enables you to:

  • Select a specific format from various formatting templates
  • Define your own number format
  • Adjust an already selected format

Steps:

  1. In the Metrics section, click Format → Custom in the fact/metric/attribute settings. 

  2. In the custom format section, do one of the following:

    • Define your own format.  In the format definition, use digit placeholders.

    • Click Templates to select from a list of predefined formats. 

    • Adjust a previously defined/selected format in the Definition section.

  3. Click Apply.

The insight now displays the numbers in your selected format.

Digit placeholders

When defining your custom number format, use the following placeholders to define the custom number format:

PlaceholderDescription

0

(zero)

Digit placeholder

The number of 0 (zeros) in the format definition corresponds with the numbers of digits displayed.

#

(hash)

Digit placeholder

Displays digits without extra 0 (zeros).

.

(dot)

Decimal point

Based on your regional settings, displays as . (dot) or , (comma).

,

(comma)

Thousands separator

Based on your regional settings, displays as , (comma) or . (dot).

%

(percentage)

Percentage placeholder

Multiplies the value by 100 and adds the % (percentage) character.

Select predefined number formats

Analytical Designer offers predefined formats you can choose from.

Steps:  

  1. In the Metrics section, click Format in the fact/metric/attribute settings. 
  2. In the drop-down menu, select a format. 

     For details, see Predefined formats table below.

The insight now displays the metrics in your selected format.

Predefined formats

NameDescriptionFormatInput exampleOutput example
InheritThe format is inherited from the definition in Manage → Metrics section.---
Rounded

Number with the thousands separator rounded to the nearest whole number.

 

#,##0

1234.5678 0.123

1,235 0

Decimal (1)Number with one decimal digit.#,##0.0

1234.5678

0.123

1,234.6 0.1

Decimal (2)Number with two decimal digits.#,##0.00

1234.5678

0.123

1234.57

0.12
Percent (rounded)Number multiplied by 100 with the thousands separator rounded to the nearest whole number.#,##0%1,234.5678

123,457%

Percent (1)Number multiplied by 100 with the thousands separator with one decimal digit.#,##0.0%1,234.5678123,456.8%
Percent (2)Number multiplied by 100 with the thousands separator with two decimal digits.#,##0.00%1,234.5678123,456.78

Default format

When you add facts, metrics, or attributes to your insight, Analytical Designer assigns the following default number formats:

  • Facts → Decimal (2)  Facts are displayed as numbers with two decimal digits.
  • Metrics   Inherited  Metrics inherit the format from their definition in the Manage Metrics section.
  • Attributes  Rounded  Attributes (count of attributes) are displayed as rounded whole numbers.