# Number settings In the Plan toolbar, navigate to **Settings > Appearance** to open up the settings side panel The **Numbers** tab in the settings side panel is used for formatting the numbers in the report. Under the Numbers section, you can find the following options for formatting the numbers in the report: ### 1. Semantic format Semantic formatting lets you highlight or emphasize positive and negative values. By enabling the toggle, you can see new fields using which you can customize the color for **positive**, **negative**, and **neutral** values. You can also choose the format for displaying the positive and negative values from the drop-down.

### 2. Value display This section provides options for null and zero display, decimal and thousand separators, and more. #### 2.1. Sign in headers If all the values in a particular row are negative, the category label will be prefixed with the minus (-) symbol indicating that every cell in that row should be multiplied by -1.

Negative sign visible with Sign in Headers enabled

When **Sign in Headers** is enabled, additional options are displayed: * **Show positive sign** Enabling the **show positive sign** toggle will prefix a plus (+) symbol before the category label for rows that contain only positive values.

Positive sign visible with show positive sign enabled

* **Show equal on totals** The total and subtotal category labels will be prefixed with an equal to (=) symbol.

Equal to sign is visible with show equal on totals enabled

#### 2.2. Null You can display a null value using blank, zero, hyphen, or enter custom text. In the image below, the **hyphen** is used to represent the null value.

When **Custom** is selected from the drop-down, the **Null text** option is enabled, where you can provide the desired text.

#### 2.3. Null as zero for calculation Reports will often contain null cells which may be used in calculated columns. In the report below, the depreciation field is calculated based on the '2023 Revenue' which has null values. Consequently, the calculated column 'Depreciation of 2023 Revenue' also contains null data.

When calculations involve measures that contain null values, you can replace the nulls with zeroes by enabling the **Null as zero for calculation** toggle.

Report where null values are replaced with zeroes

#### 2.4. Zero Similar to null values, you can display a zero value using **blank**, **zero**, **hyphen**, or enter **custom** text.

When **Custom** is selected from the drop-down, the **Zero text** option is enabled, where you can provide the desired text.

#### 2.5. Max decimal precision You can set the maximum number of digits to display after the decimal point.

#### 2.6. Decimal separator You can insert the desired **decimal separator** in this field. By default, dot (.) is used.

#### 2.7. Thousand separator You can insert the desired **thousand separator** in this field. By default, comma (,) is used.

#### 2.8. Suppress calculation errors This option can be used to hide calculation errors. You can also define custom error text that will be displayed in case of calculation errors.

#### 2.9. Blank row label By default, blank rows or columns are identified as '(Blank)'. This can be customized by entering the desired text in the field.

#### 2.10. Blank column label If you have blank dimension categories in your columns, Plan replaces the empty column headers with "(Blank)". You can provide alternate text to use in the **Blank Column Label** textbox.

### 3. Units This section lets you specify the labels for units and left-align prefixes. You can navigate to **Settings** > **Number** > **Units** to align & customize the labels. By default, the prefix is displayed immediately before the number. The image below indicates how the prefixes are displayed before enabling the left-align prefix option.

Alignment when left-align prefix toggle is disabled

Alignment when left align prefix toggle is enabled

Alignment when right-align suffix toggle is enabled

#### 3.3. Display prefix as unit for null values Enabling this toggle allows you to apply the unit prefix to cells with null values.

#### 3.4. Custom label This option lets you customize the unit labels. Once you turn on the toggle, additional options are displayed: **Column scaling label**, **Short**, **Medium**, and **Large** text fields. The default settings are shown in the image below.

Showcasing default options of column scaling label

The customized **Medium** column scaling label is shown in the image below.

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.fabricplan.com/display-settings/number-settings.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.