# Number settings Under the Numbers section in Display settings, you can use the following options for formatting numbers in your reports: #### 1. Semantic format Semantic formatting allows you to highlight or emphasize positive and negative values. When you enable the toggle, you will be able to 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. Show (-ve) sign** This option lets you display negative numbers within parentheses, as shown in the image. {% hint style="info" %} The 'Show (-ve) sign' checkbox is enabled only when the 'Semantic formatting' toggle is turned off. {% endhint %}

#### **2.2. Null** You can replace null values using blank, zero, hyphen, or enter custom text. When **Custom** is selected from the drop-down, the **Null text** option is enabled - you can provide the desired text to replace nulls (a maximum of six characters). In the image, the hyphen is used to represent null values.

#### **2.3 Null as zero for calculation** Reports often contain null cells that may be used in calculated columns. In the report below, the *Absolute Variance (2026)* field is calculated using the *2026 Actuals* and *2026 Plans* measures, which contain null values. As a result, the *Absolute Variance* measure also includes 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.

#### **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 - you can provide the desired text to replace zeroes(a maximum of six characters). In this example, we've used ZERO to replace 0's in the Budget field.

#### **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, the 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** When a calculation error occurs during data processing, the error message is suppressed and handled to prevent disruption in report rendering. 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 are identified as '(Blank)'. This can be customized by entering the desired text in the **Blank Row Label** textbox. In this example, blank sub categories have been replaced with 'NO Data'.

### 3. Unit Specify the labels for scaling units and left-align prefixes. #### **3.1 Left-align prefix** By default, the prefix is displayed just before the number. The image below indicates how the prefixes are displayed when the left-align prefix option. is disabled

On enabling the left-align prefix option, the prefix is aligned to the left of the cell.

#### **3.2 Right-align suffix** Similar to the left-align prefix option, you can align the suffix to the right side of a cell.

#### **3.3 Custom label** This option lets you customize the scaling labels. When you enable the toggle, additional options are displayed. Select 'Short', 'Medium', or 'Large' from the **Column scaling label** dropdown. The default settings are shown in the image.

The customized 'Medium' column scaling label is shown.

#### FAQs **Q1: Do number settings affect data accuracy or calculations?** No. Number settings only change how values are displayed in the visual. They do not modify the underlying data, calculations, or measures, ensuring your reports remain accurate and reliable. **Q2: Can I control rounding and decimal precision?** Yes. You can specify how many decimal places to display and control rounding behavior to ensure KPIs are shown with the right level of accuracy.