Skip to main content
Hitachi VantaraPentaho Documentation
Pentaho Documentation

Number Formatting

Analyzer can format number fields in a few different ways:

  • Default: Uses the cell formatter specified in the Mondrian schema
  • General Number: A number that can be separated by commas and decimal places, but has no sign. Pound symbols represent number places if they exist, and zeroes represent potential holders for places that do not exist. So for a definition of 00#,###.00, the number 11223.4 would be represented in Analyzer as 011,223.40.
  • Percentage: A number that can be separated by commas and decimal places, followed by a percent sign. Pound symbols represent number places if they exist, and zeroes represent potential holders for places that do not exist. So for a definition of 00#,###.00%, the number 11223.4 would be represented in Analyzer as 011,223.40%.
  • Currency: A number that can be separated by commas and decimal places, preceded by a currency sign. Pound symbols represent number places if they exist, and zeroes represent potential holders for places that do not exist. So for a definition of $00#,###.00, the number 11223.4 would be represented in Analyzer as $011,223.40.
  • Expression: A custom format defined by some user-supplied logic. See Advanced Conditional Formatting With MDX Expressions for more information.

To change the formatting of a measure, right-click on it in the grid, then select Column Name and Format... from the context menu.

Note: Formatting options apply to both the report viewer and exports (PDF, XLS).