Inforiver
Analytics+
Analytics+
  • Introduction to Analytics+
    • Installing Analytics+
      • Install for yourself
      • Installing from AppSource
      • Installing for your organization
    • Licensing and manual renewal
  • Working with Analytics+
    • 1. Navigating the Analytics+ toolbar
      • Chart toolbar
      • Card toolbar
      • Table toolbar
    • 2. Data Management
      • Advanced pivot
      • Adding calculated measures
    • 3. Charts
      • 3.1. Charts - getting started
      • 3.2. Quick options - charts
        • X-axis customizations
        • Y-axis customizations
      • 3.3. Configure measures for charts
      • 3.4. Configure dimensions for charts
      • 3.5. Chart discoverability
      • 3.6. Data label customizations
      • 3.7. Deviation
      • 3.8. Display settings for charts
        • Charts - canvas settings
        • Charts - axis settings
        • Charts - number settings
        • Charts - legend settings
        • Charts - other settings
          • Charts - tooltip settings
    • 5. Cards
      • 5.1. Cards - getting started
      • 5.2. Quick options-cards
        • KPI customizations
        • Chart customizations
      • 5.3. Configure measures for cards
      • 5.4. Configure dimensions for cards
      • 5.5. Insight charts
      • 5.6. Variance customizations
      • 5.7. KPI containers
        • Working with Groups
        • Working with Flex components
      • 5.8. Inserting formulas & text
      • 5.9. Card customizations
      • 5.10. Display settings for cards
        • Cards - canvas settings
        • Cards - number settings
        • Cards - legend settings
        • Cards - axis settings
        • Cards - other settings
          • Cards - tooltip settings
    • 6. Tables
      • 6.1. Tables - getting started
      • 6.2. Quick options - tables
      • 6.3. Configure measures for tables
      • 6.4. Configure dimensions for tables
      • 6.5. Formatting data
      • 6.6. Number formatting
      • 6.7. Inline charts
      • 6.8. Blend measures
      • 6.9. Row gripper options
      • 6.10. Display settings for tables
        • Tables - canvas settings
        • Tables - number settings
        • Tables - other settings
          • Tables - tooltip settings
    • 7. Trellis customizations
      • Charts trellis layout
      • Cards trellis layout
      • Tables trellis layout
    • 8. Customize measures
      • Charts measure series
      • Cards measure series
      • Tables measure series
    • 9. Splitting and grouping measures
      • Splitting and grouping: charts
      • Splitting and grouping: cards
      • Splitting and grouping: tables
    • 10. Conditional formatting
      • One-click rules
        • One click rules for charts
        • One click rules for cards
        • One click rules for tables
      • Configuring rules
        • Configuring rules for charts
        • Configuring rules for cards
        • Configuring rules for tables
        • Variable conditional formatting rules
        • Applying conditional formatting rules
      • Setting color scales
      • Managing rules
    • 11. Sort & Reorder data
      • Sorting data
      • Advanced sorting
      • Reordering data
    • 12. Ranking data - TopN
      • Ranking for charts
      • Ranking for cards
      • Ranking for tables
      • Dynamic ranking with numeric parameters
    • 13. Adding notes
      • Notes for charts
      • Notes for tables
    • 14. Data selection
    • 15. Working with hierarchies
      • Hierarchies in charts
      • Hierarchies in cards
      • Hierarchies in tables
      • Unbalanced hierarchies
      • Single child hierarchies
    • 16. Summary tables
    • 17. Backup and restore
    • 18. Context awareness
    • 19. Image support
      • Images in cards
      • Images in tables
    • 20. Analytics
      • Reference line
      • Reference band
      • Error bar
      • Trend line
      • Additional series
    • 21. Keyboard shortcuts
    • 22. Reading view access
    • 23. Row aggregation
  • Storyboard
    • Element customizations
    • Board customizations
    • Working with textboxes
    • Uploading images
    • Using shapes
    • Inserting slicers
    • Element interactions
    • Layers
    • Navigation
      • Play axis
    • Annotations
  • Gantt chart
    • Gantt: Canvas settings
      • Gantt: General settings
      • Gantt: Column settings
      • Gantt: Grid settings
      • Gantt: Timeline settings
    • Gantt milestones
    • Gantt: Data label settings
    • Gantt: Conditional formatting
    • Gantt: Web URLs
    • Gantt resource
    • Gantt: Zoom levels
  • Quick charts
    • Waterfall charts
    • Marimekko
    • Column/Bar charts
    • Bullet charts
    • Area charts
    • Pie charts
    • Treemap charts
    • Radar/Polar charts
    • Funnel charts
    • Sunburst charts
    • Bubble charts
    • Boxplots
    • Histogram
    • Gauge
    • Storytelling charts
      • Range charts
      • Ribbon chart
      • Tornado chart
      • Multi-variate charts
      • Sankey charts
    • Combo charts
  • Release notes
    • Analytics+ April 2025 update - Release 4.7
    • Analytics+ March 2025 update - Release 4.6
    • Analytics+ January 2025 update - Release 4.5.
    • Analytics+ January 2025 update - Release 4.3
    • Analytics+ November 2024 update -Release 4.2
Powered by GitBook
On this page
  • 1. Enable number format
  • 2. Display
  • 3. Include signs at extreme
  • 4. Show in percentage points
  • 5. Show in basis points
  • 6. Prefix/Suffix
  • 7. Separator
  • 8. Null
  • 9. Zero
  • 10. Value format
  • 11. Custom label
  • 12. Measure formatting
  1. Working with Analytics+
  2. 5. Cards
  3. 5.10. Display settings for cards

Cards - number settings

PreviousCards - canvas settingsNextCards - legend settings

Last updated 1 year ago

The number formatting tab enables you to customize the data values rendered in the report. In this section, let's explore the number formatting options for setting the scaling, precision, null handling, measure display, etc.

1. Enable number format

Number formatting is enabled by default. You can disable this option to view the raw data values without applying formatting. Data values that exceed millions or billions are difficult to comprehend without number formatting.

The readability of metrics and values is greatly improved when number formatting is enabled.

2. Display

2.1. Display format

Each data point's scaling factor is displayed when the Custom option is selected. The scaling factor is set at the report level when the IBCS display format is used.

When the Custom format is chosen, the scaling factor is displayed against each KPI header and data point. When the IBCS format is used, the scaling is set uniformly and is displayed in the report title.

2.2. Scaling

You can customize the scaling factor based on your data. You can choose the Flexible option for data with mixed granularity (some values are in thousands, some in millions, etc). Analytics+ will automatically set the same scaling factor for the entire report when you choose the Uniform option. You can also set a custom scaling factor of thousands, billions, millions, etc.

The scaling factor is applied to the data points and KPI header.

2.3. Decimal places

Set the precision i.e. number of decimal places to display for each data point. In card mode, the precision setting will be applied to the KPI metrics and data points.

3. Include signs at extreme

The positive or negative signs will be displayed at the leftmost end of the value, before any prefix.

4. Show in percentage points

Percentage points are a simple way to express changes or differences in percentages. It is often used in contexts such as Interest or FX rates. For example, a decrease from 5% to 3% represents a change of 2 percentage points. With Analytics+ you can express the variance in percentage points.

Set the Scaling option to Percentage to represent data values in percentage points.

5. Show in basis points

Basis points are used in finance and economics to describe small changes in percentages, especially when discussing interest rates, bond yields, or other financial metrics. One basis point equals one-hundredth of a percentage point (0.01%). Analytics+ enables you to express variances in basis points.

Set the Scaling option to Percentage to represent data values in basis points.

6. Prefix/Suffix

Adding a prefix or a suffix to your values can provide more context around what the value represents. For example, a Cost measure may indicate the cost per unit or a Price measure may be the price in dollars. In the example, the Actuals are in dollars, we've added a $ prefix to capture that in the chart.

The prefixes/suffixes are applied to the KPI metrics and data values for cards.

7. Separator

You can set the decimal and thousand separators using the options in this section. We've set the thousand separator to ", " in the example.

8. Null

It is a common occurrence for data to contain null or blank values. This could be due to missing data entry, data processing errors, or data quality issues. Reports should be able to handle missing data gracefully - Analytics+ provides a range of null handling options to achieve this. Notice the null values in the Depreciation account? In this section, we'll look at the options available in Analytics+ to handle the null values.

8.1. Treat null as zero

You can consider null values as zero by enabling the toggle. We have plotted charts only for the domestic and APAC regions to demonstrate this option.

8.2. Suppress nulls

This option comes into play when all the values in a particular category are blank. For instance, if you have actuals and plan measures, you can suppress nulls only if both measures are blank for a particular category. In the APAC region, notice how the Depreciation category is not plotted when nulls are suppressed.

8.3. Suppress null variance

You can choose not to plot null variances. Consider that you have actuals and plan measures. The variance will be null if the plan measure is null (or actuals is null) for a particular category - you can suppress such null variances. In the example, notice how the variance has been suppressed for the Net Cash category.

8.4. Include null in calculations

Null values will be considered for calculations when this property is enabled. In the example, notice how the position of the average line changes when this property is enabled or disabled.

9. Zero

If your data contains values with zeroes, Analytics+ offers multiple options to display them in your reports. You can display zeroes as blank, zero, null, or hide them in reports.

Zeroes have been displayed as blanks in the example.

  • You can choose to hide categories with zero values in your reports by enabling the Suppress zeros toggle.

When you have more than one measure, suppress zero will work only if both measures are 0.

The Common Stock and Long-Term Debt categories have been suppressed in the LATAM panel when the Suppress zeros setting is enabled. The Domestic panel still has these two categories.

10. Value format

You can set a custom color scheme for positive and negative values in your reports. You can also customize how to display positive(X, +X, X+) and negative(X, -X, X-, (X)) values. Enable the Value color toggle to set these options.

In this example, we have displayed the positive values and variances in black and the negative values in red.

11. Custom label

With Analytics+, you can even customize the notations for thousands, millions, billions, percentage points, or basis points. Enable the Custom Label toggle set assign notations.

In this example, we have set custom notations for thousands and millions.

12. Measure formatting

You can set the scaling, decimal precision, and prefix/suffix for individual measures as well. Enable the toggle against a measure to format it. In the examples, we applied number formatting options for the 2024 Actuals measure and used default formatting for the 2024 Plan measure.

Individual measure formatting options are enabled when the display format is set to Custom. For IBCS, uniform scaling is applied for all measures at the report level.

Number formatting disabled
Number formatting enabled
Custom display format - scaling factor displayed for each data point
IBCS display format
Scaling factor for cards
Decimal precision for cards
Include signs at extreme for cards
Percentage points for cards
Variance in Basis points
Prefix/Suffix for cards
Thousand separator applied
Null values in the data
Treat null as zero
Suppress nulls
Suppress null variance
Include null in calculations
Displaying zeroes
Zeroes suppressed
Format for values for variances
Custom notations for cards
Individual measure formatting