Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Numeric Report Formatting

You can set the numeric formatting for any report element that of the data type number, currency, and percent. Numeric formatting does not affect non-numeric values such as text or dates and does not affect the data on sheets.

Numeric Formatting Availability: Matrix, Modeled, Transaction reports

To specify the formatting for numeric values on a report:

  1. Right-click the numeric element from design area of the report builder and select Format from the menu.
  2. On the Number tab, set the numeric formatting for the element (format options are explained below). You can see a preview of your changes.
  3. Click Apply to save changes.

Display Zeroes Format

Options include:

  • Use account's format: zeroes are formatted according to the Display Zero As option selected for the accounts that intersect the element you are formatting in the report. This option only appears when you are formatting a non-account element in a Matrix report and is the default choice for non-account elements.
  • 0: Zeroes are displayed as "0" in the report. Default.
  • - : Zeroes are displayed as a dash ( - ) in the report.
  • Blank: Zeroes are displayed as empty cells in the report. When a cell has no data the cell is automatically displayed as blank. 

Precision Format

Options include:

  • Use account's precision: Uses the decimal precision set in the Account Details section in the Modeling > Model Management > Accounts page. For a cube account, the Cube Accounts page in the cube sheet builder. This option only appears when you are formatting an account element and is the default choice for account elements.
  • Use the account format: uses the precision set for any account/accounts that intersect the element you are formatting in the report. This option only appears when you are formatting a non-account element in a Matrix report and is the default choice for non-account elements.
  • -9 to 9: Select a specific precision for account and non-account numeric elements.
    • Positive precision:A positive number indicates the number of decimal places to display. For example, a precision of 2 means that decimals are displayed to the hundredths place.
    • Negative precision: A negative number indicates that numbers to the left side of the decimal are rounded to a specified number of digits. For example, -2 precision means that all values are rounded to the nearest hundred.

1000 Separator (,) Format

Options include:

  • Use account's format: Numbers are formatted based on the 1000 Separator option selected for the accounts that intersect the element that you are formatting. This option is available for non-account elements in Matrix and Transaction reports and is the default for non-account elements.
    • Show 1000 separator: The 1000 separator specified by your browser locale is displayed. Default setting for account elements.
    • Hide 1000 separator: The numeric value is displayed without the 1000 separator.

Magnitude Format

Options include:

  • Use account's format: Numbers are formatted according to the Magnitude option selected for the accounts that intersect the element that you are formatting. This option only appears for non-account elements in Matrix reports and is the default choice for non-account elements.
  • Show value: Numeric values are displayed as they are stored in the database. This is the default setting for account elements.
  • Show in thousands: Numeric values are divided by 1,000 to display the number in thousands.
  • Show in millions: Numeric values are divided by 1,000,000 to display the number in millions.

Negative Number Format 

Options include:

  • Negative sign in automatic text color: Negative numbers are displayed with negative sign in the text color set in the Display format tab.
  • Red text: Negative numbers are displayed in red text.
  • Parentheses in automatic text color: Negative numbers are displayed within parentheses in the text colorset in the Display format tab.
  • Parentheses in red text: Negative numbers are displayed in red text and within parentheses.

Display examples of these options:

 

  • Was this article helpful?