Loading
CRM Analytics
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Format Numbers

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            Format Numbers

            Choose either preset or custom number formats. Specify custom formats for positive, negative, and zero values.

            Required Editions

            Available in Salesforce Classic and Lightning Experience.
            Available with CRM Analytics, which is available for an extra cost in Enterprise, Performance, and Unlimited Editions. Also available in Developer Edition.
            User Permissions Needed
            To view visualizations: Use CRM Analytics
            1. Click Button dropdown for formatting from left panel on any measure field.
            2. Choose Format Numbers and choose a preset format.
              fullscreen showing menu for custom number format
              1. Click Custom… for more presets or to specify your own custom format.
                custom number format modal
              2. Use a preset or enter a custom string in the Format string.

              For multiple formats, use this syntax: <POSITIVE_FORMAT>;<NEGATIVE_FORMAT>;<ZERO_FORMAT>.

              The Format string always uses a comma (,) for the thousands separator and a period (.) for the decimal separator. Change the separator in the Thousands or Decimal string to override the separator in the Format string. CSV downloads ignore the specified separators and always use the default values of comma (,) for thousands and period (.) for decimal.

            3. Click Done to save the format.
              Note
              Note In the Spring ’20 release we unified number behavior in charts, tables, and number widgets.
              • 0 values follow formula logic. For example, a format string $#.## with a 0 value returns $0.00.
              • Default behavior never returns a negative 0.
              • Short numbers like 1.0x always return 1.0x, not 1x.
              • Negative and zero formats are optional.
             
            Loading
            Salesforce Help | Article