MicroStrategy ONE

Properties and Formatting Dialog Box: Number

If you arrived here from Workstation, see the Workstation Document Authoring Help.

You can specify a number format for text in a text field using the following Number options in the Properties and Formatting dialog box. The Number options are displayed only if a text field is selected.

When you select one of the number format options, an example of the number category and additional options are displayed on the right. For example, you can choose to display numbers as currency and also determine the number of decimal places for the values.

  • Default
  • General
  • Fixed: If you select Fixed as the category, you can determine the number of decimal places to be displayed, whether you want numbers to be separated every three decimal places, and whether negative numbers are allowed.
  • Currency
  • Date: If you select Date as your category, you need to choose which date Type to use, such as 4/12/07, April 12, 2007, 4/7/2007, and so on.
  • Time
  • Percentage
  • Fraction
  • Scientific

  • Custom: Define your own custom number format if none of the existing formats meet your needs. To do so, enter the number formatting symbols, such as 123,456.789.

    For internationalization, you can use the Custom option to create a dynamic currency format that changes according to the locale's default currency symbol (select the Number and Date Format language in the General preferences). The dynamic currency is displayed in documents displayed in MicroStrategy Web (including graphs), MicroStrategy Mobile, and MicroStrategy Office and exported to PDF. For a graph report, the dynamic currency is applied to the data label.

    Define the custom format in the Type field as:

    ¤#,###.00

    where the ¤ character is created by pressing the ALT key while typing 0164. The ¤ character is replaced with the locale's default currency. For example, if the Number and Date Format is set to German (Germany), then a numeric value in this format is displayed as €1.234,56. If the Number and Date Format is set to German (Switzerland), the numeric value is displayed as Fr.1'234.56.

    The syntax shown above displays the currency symbol before the number, but you can change its location. For example, to display the currency symbol after the number, use #,###.00¤; to display it before the number with a space, use ¤ #,###.00.

    Once you create a custom format, you can use it in other metrics as well by clicking Custom in the Category list and selecting the format from the Custom drop-down list.

  • From Grid: Inherit number formatting options from the Grid.