Comma Format Options in Number Formatting

Comma Format Options in Number Formatting

 


  • Overview
    • Comma Format options allow users to display numbers based on region-specific digit grouping and separators.
    • These options are available under the Comma Format dropdown and are enabled only when comma formatting is turned ON.

    • Supported across all formatters where number formatting is applicable, such as:
      • Data Labels
      • Values
      • Totals
      • Tooltip
      • Axis Labels
  • Compatibility
    • Works seamlessly with other number formatting options (decimal places, scaling, prefixes/suffixes, etc.).

 

Available Comma Format Options (with Example)

  • Sample Value Used: 13322231.45
  • Available format options are as below:

 

  • en-IN (Indian Number System)
    • Formats numbers using lakh and crore grouping.
    • Formatted Value: 1,33,22,231.45
    • Grouping pattern: 3 digits (rightmost), then 2 digits.

 

  • en-US (US Number System)
    • Standard international grouping with commas.
    • Formatted Value: 13,322,231.45
    • Grouping pattern: 3 digits throughout.

  • en-GB (UK Number System)
    • Similar to US format with standard comma separation.
    • Formatted Value: 13,322,231.45
    • Grouping pattern: 3 digits throughout.

 

  • de-DE (German Number System)
    • Uses dot (.) as thousand separator and comma (,) as decimal separator.
    • Formatted Value: 13.322.231,45

 

Key Notes

  • These formats only affect visual representation, not the underlying data.
  • Useful for localization and improving readability for region-specific users.
  • Can be combined with Display Unit Mapping  (K, M, B) and decimal precision settings.

Refer Number Format details here.

 


    • Related Articles

    • Number Format

      Number Formatting allows you to change the way numerical entities appear on the X and Y-axes. It is applicable for features under Measures (numerical variables). The figure below shows the available Number Format options. The table given below ...

    • Formatting a Chart

      This formatting is applicable for widgets that do not have axes. For example, chart formatting is possible for widgets such as Pie Chart and Donut Chart. To format the chart, follow the steps given below. Create the number of charts as required. ...

    • Date and Time Formatting on Chart

      In RubiSight, when you plot a chart using the Date and Time formatting feature, the coordinates of the plot appear in the standard ISO format, by default, as given below. Format: YYYY-MM-DD HH:MM:SS Where, YYYY-MM-DD is the date components of the ...

    • Card Chart Data Labels Datetime formatting

      Card chart when plotted with Date/Interval column types with Minimum/Maximum aggregation shows the Minimum/Maximum date out of that column. Default date format is displayed in ISO format. The customization for datetime can be done using the available ...

    • Formatting a Chart

      This formatting is applicable for widgets that do not have axes. For example, chart formatting is possible for widgets such as Pie Chart and Donut Chart. The figure given below shows the available formatting options for a chart. These options may ...