---
title: "Formatting Numbers in Insights"
slug: "formatting-numbers-in-insights"
updated: 2023-07-10T20:05:27Z
published: 2023-07-10T20:05:27Z
canonical: "docs.foundationhub.com/formatting-numbers-in-insights"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.foundationhub.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Formatting Numbers in Insights

- Use the Number Format Editor to configure how numbers appear in your Insights. You can round numbers, add currency symbols, adjust colors, or append numbers with sets of characters.
- To access the Number Format Editor, use the drop-down next to your selected metric. Click on the arrow next to “Format: ___” to see a list of pre-set number formats and a custom option. ![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-1689017441331.png)![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-1689017460620.png)
- Formatting changes made in the Number Format Editor modify formatting for the entire Workspace.

**Rounding to a Whole Number and Decimal Places**

- Use the Number Format Editor to change the rounding of numbers in your Dashboard.
- The number of hash symbols (#) to the right of the decimal point dictates the number of decimal place values to display. If a number has more decimal places than the number of hash symbols, the number will be rounded.
  - Use zeroes in place of hash symbols to ensure that whole numbers will be given decimal places:![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-1689017221410.png)
  - Use commas in between the hash symbols if you would like your numbers to have commas. #,### means that commas will be used in accordance with number rules. (i.e. 123456789 will be written as 123,456,789)
- When you have decided the format of your numbers, use the above notation in the Number Format Editor:![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-1689017583771.png)
- You can also select any of the presets in the Formatting menu:![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-1689017720227.png)
  - Each preset has an example number that demonstrates the format it will apply to your Dashboard.

**Conditional Number Formatting**

- You can create conditions using the "Custom" option in the Formatting menu.![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-1689019465871.png)
- Conditions are formed using brackets and their numerical ranges are defined with the following symbols:
  - Greater than: >
  - Greater than or equal to: >=
  - Less than: <
  - Less than or equal to: <=
  - Equal: =
- Example condition:![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-1689019479566.png)
  - #,###.##[>1,000][red] means that numbers will be rounded to the hundreths place and any number greater than 1,000 will be colored red.
  - You can add a second condition using a semicolon:![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-1689019490949.png)
    - Now, numbers greater than 1,000 will be displayed in red and numbers less than 1,000 will be displayed in green.
  - You can add as many conditions as you would like as long as they do not conflict with each other. (ex. You could not write [>1,000][purple]#,###.##; [>100,000][red]#,###.## because the two conditions are overlapping).