---
sourceDocument: Zurich Platform Analytics
sourceDocumentLink: https://www.servicenow.com/docs/r/zurich/now-intelligence

 Release :

    - zurich

ft:locale :

    - en-US

ft:publication_title :

    - Zurich Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Value formatting in reports

# Value formatting in reports {#ariaid-title1}

* Release version: Zurich
* 
* Updated July 31, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

In most reports, you can configure how numerical values look when you publish the
report.

## Supported value formats {#value-formatting-reports__section_ndk_q3l_r4b}

A limited number of visualization types support value formatting. {#value-formatting-reports__simpletable_a23_ggc_cqb__entry__2}

| Visualization type | Supported value formats |
|-|-|
| Single score | Both number and duration formatting |
| Multilevel pivot | Both number and duration formatting |
| Horizontal and vertical bar | Only duration formatting |
| Pie | Only duration formatting |
| Time series visualizations (Area, column, line, spline, and step line) | Only duration formatting |
| Geomap | Only duration formatting |
[Table 1.]

{#value-formatting-reports__simpletable_a23_ggc_cqb}

Formatting applies for aggregate values.

## Types of value formatting {#value-formatting-reports__section_ck5_rqn_nnb}

Unit format
:   Show the format of time fields as d/h/m/s or day/hour/minute/second.

Maximum/Minimum duration unit
:   Select the largest or smallest unit to be shown: Day, Hour, Minute, or Second.

Hide seconds when unit is greater than one minute
:   Removes seconds display when a duration value is greater than one minute. Only
    available if you choose Second as the minimum duration
    unit.

Decimal precision
:   Number of decimal places to show, from zero to four decimal
    places.  
    Note:  
    Decimal precision is not supported on currency fields.

Rounding
:   For values greater than one minute, simplifies a number by rounding, while keeping
    it close to its value. See [Rounding options](https://www.servicenow.com/docs/pwtppjLjSf_qJesz8Y343A#value-formatting-reports__section_pb5_v5n_nnb).

Use the thousands group separator
:   Separate a value of thousands or higher with a comma or period.

Enable abbreviation
:   Show a value of thousands or higher with a single character.  
    Note:  
    Abbreviation for Currency, Price, or FX Currency values is not supported.

Hide value in tooltip
:   Do not show the unrounded, unabbreviated value in the tooltip.

## Rounding options {#value-formatting-reports__section_pb5_v5n_nnb}

For values greater than one minute, rounding options simplify a number, but keep it close to its value. Select from these rounding options:

* Up - to the next larger whole number if positive and to the next smaller whole number if negative. Example: For original values of:
  * 1.1 returns a value of 2
  * 1.6 returns a value of 2
  * -1.6 returns a value of -2
  {#value-formatting-reports__ul_vhl_qv1_5mb}
* Down - to the next smaller whole number if positive and to the next larger whole number if negative. Example: For original values of:
  * 1.1 returns a value of 1
  * 1.6 returns a value of 1
  * -1.6 returns a value of -1
  {#value-formatting-reports__ul_whl_qv1_5mb}
* Ceiling - to the next larger whole number, toward the positive. Example: For original values of:
  * 1.1 returns a value of 2
  * 1.6 returns a value of 2
  * -1.6 returns a value of -1
  {#value-formatting-reports__ul_xhl_qv1_5mb}
* Floor - to the next smaller whole number, toward the negative. Example: For original values of:
  * 1.1 returns a value of 1
  * 1.6 returns a value of 1
  * -1.6 returns a value of -2
  {#value-formatting-reports__ul_yhl_qv1_5mb}
* Half up - to the nearest neighboring whole number. If both neighbors are equidistant, rounds to the next larger whole number. Example: For original values of:
  * 1.1 returns a value of 1
  * 1.6 returns a value of 2
  * 2.5 returns a value of 3
  {#value-formatting-reports__ul_n1n_sqn_nnb}
* Half down - to the nearest neighboring whole number. If both neighbors are equidistant, rounds to the next smaller whole number. Example: For original values of:
  * 1.1 returns a value of 1
  * 1.6 returns a value of 2
  * 2.5 returns a value of 2
  {#value-formatting-reports__ul_o1n_sqn_nnb}
* Half even - to the nearest whole number. If both neighbors are equidistant, rounds to the closest even number. Example: For original values of:
  * 1.1 returns a value of 1
  * 1.6 returns a value of 2
  * -2.5 returns a value of -2
  {#value-formatting-reports__ul_p1n_sqn_nnb}
{#value-formatting-reports__ul_m1n_sqn_nnb}

Summary of rounding options:
{#value-formatting-reports__table_u2h_1cf_w4b__entry__8}

| Input number | Up | Down | Ceiling | Floor | Half up | Half down | Half even |
|-|-|-|-|-|-|-|-|
| 5.5 | 6 | 5 | 6 | 5 | 6 | 5 | 6 |
| 2.5 | 3 | 2 | 3 | 2 | 3 | 2 | 2 |
| 1.6 | 2 | 1 | 2 | 1 | 2 | 2 | 2 |
| 1.1 | 2 | 1 | 2 | 1 | 1 | 1 | 1 |
| 1.0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| -1.0 | -1 | -1 | -1 | -1 | -1 | -1 | -1 |
| -1.1 | -2 | -1 | -1 | -2 | -1 | -1 | -1 |
| -1.6 | -2 | -1 | -1 | -2 | -2 | -2 | -2 |
| -2.5 | -3 | -2 | -2 | -3 | -3 | -2 | -2 |
| -5.5 | -6 | -5 | -5 | -6 | -6 | -5 | -6 |
[Table 2. Result of rounding input to one digit with the given rounding mode]

{#value-formatting-reports__table_u2h_1cf_w4b}

## Configure formatted values in reports {#ariaid-title2}

In existing reports, you can configure formatted values on the
Configure tab of the Report Designer.

### Before you begin

Role required: itil, report_user, report_group, report_global, report_admin, or admin

### Procedure

1. Navigate to AllReportsView / Run.
2. Select the report with the values you want to format.
3. Select the Configure tab.
4. Click Set Value Formatting.
5. In the Value Formatting window, configure duration, decimal precision, rounding options, unit separators, and abbreviations.  
   Value formatting options for a single score report with Count aggregation:

*[\>]: and then