Number settings

Customize number formatting, value display, and semantic styling across the report.

In the Lumel EPM 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.

Applying semantic format

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.

Replacing blank values with hyphen

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

Replacing blank values with cutom 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.

Report with null values

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.

Showcasing options for zero values

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.

Setting max decimal precision

2.6. Decimal separator

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

Setting decimal separator

2.7. Thousand separator

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

Setting thousand separator

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.

Setting custom error text

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.

Customizing blank row label

2.10. Blank column label

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

Customizing blank column label

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.

Displaying unit prefix for 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.

Setting desired column scaling label