# Tables - number settings The number formatting tab enables you to customize the data values rendered in the report. In this section, let's explore the number formatting options for setting the scaling, precision, null handling, measure display, etc. ### 1. Enable number format Number formatting is enabled by default. You can disable this option to view the raw data values without applying formatting. Data values that exceed millions or billions are difficult to comprehend without number formatting.

The readability of data points is vastly improved when number formatting is enabled.

### 2. Display #### 2.1. Display format Each data point's scaling factor is displayed when the **Custom** option is selected. The scaling factor is set at the report level when the **IBCS** display format is used.

#### 2.2. Scaling You can customize the scaling factor based on your data. You can choose the **Flexible** option for data with mixed granularity (some values are in thousands, some in millions, etc). Analytics+ will automatically set the same scaling factor for the entire report when you choose the **Uniform** option. You can also set a custom scaling factor of thousands, billions, millions, etc. When the scaling option is set to 'Flexible', notice how the scaling factor for the absolute variance column varies for different rows based on the granularity.

#### 2.3. Decimal places Set the precision i.e. number of decimal places to display for each data point.

### 3. Include signs at extreme The positive or negative signs will be displayed at the leftmost end of the value, before any prefix.

### 4. Show in percentage points Percentage points are a simple way to express changes or differences in percentages. It is often used in contexts such as Interest or FX rates. For example, a decrease from 5% to 3% represents a change of 2 percentage points. With Analytics+ you can express the variance in percentage points. {% hint style="info" %} Set the Scaling option to Percentage to represent data values in percentage points. {% endhint %}

### 5. Show in basis points Basis points are used in finance and economics to describe small changes in percentages, especially when discussing interest rates, bond yields, or other financial metrics. One basis point equals one-hundredth of a percentage point (0.01%). Analytics+ enables you to express variances in basis points. {% hint style="info" %} Set the Scaling option to Percentage to represent data values in basis points. {% endhint %}

### 6. Prefix/Suffix Adding a prefix or a suffix to your values can provide more context around what the value represents. For example, a Cost measure may indicate the cost per unit or a Price measure may be the price in dollars. In the example, the Actuals are in dollars, we've added a $ prefix to capture that in the chart. In the case of tables, when you add a prefix from display settings, it gets applied globally to all the columns in the report. To add a prefix for a specific column, select the column and use the number formatting options from the toolbar. [Learn more about using the toolbar.](/analytics+/working-with-analytics+/1.-navigating-the-analytics+-toolbar.md)

### 7. Separator You can set the decimal and thousand separators using the options in this section. We've set the thousand separator to ", " in the example.

### 8. Null It is a common occurrence for data to contain null or blank values. This could be due to missing data entry, data processing errors, or data quality issues. Reports should be able to handle missing data gracefully - Analytics+ provides a range of null handling options to achieve this. In this sub-section, we'll look at the options available in Analytics+ to handle the null values. #### 8.1. Treat null as zero You can consider null values as zero by enabling the toggle. Notice how the variance field changes when nulls are considered as zeroes

#### 8.2. Suppress nulls This option comes into play when all the values in a particular measure are blank. Let's consider the EMEA and LATAM regions. Notice how the Depreciation account is null for Actuals and Plan in EMEA.

When you suppress nulls, the Depreciation account will not be displayed for EMEA but LATAM is not impacted as it has non-null values in the Plan

#### 8.3. Suppress null variance When there are multiple comparative measures involved, Analytics+ calculates the variance. If comparative measures contain null values, the variance for those rows will also be null. You can choose to display a variance of 100% (positive or negative based on the data) instead of blank values.

### 9. Zero If your data contains values with zeroes, Analytics+ offers multiple options to display them in your reports. You can display zeroes as blank, zero, null, or hide them in reports. In the table, zero is displayed as Null.

* You can choose to hide categories with zero values in your reports by enabling the Suppress zeros toggle. {% hint style="info" %} When you have more than one measure, suppress zero will work only if both measures are 0. {% endhint %} The Depreciation category has Actuals and Plan equal to 0.

When zeros are suppressed, the Depreciation category no longer shows on the report.

### 11. Custom label With Analytics+, you can even customize the notations for thousands, millions, billions, percentage points, or basis points. Enable the Custom Label toggle set assign notations. In the example, we have set a custom notation for million which has been applied across the report.

--- # 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.inforiver.com/analytics+/working-with-analytics+/5.-tables/5.10.-display-settings-for-tables/tables-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.