Inforiver comes packaged with intelligent number format & scaling recognition capabilities that help display data in a perceptive manner right out of the box. The in-built intelligence does the hard work so that you do not have to.

Let us take a sample dataset as shown below. You can immediately spot data of mixed granularity – with values in millions, thousands, and even one that is just a few dollars’ worth.

Intelligent & Automated Number Formatting for Tables

Let us see how Inforiver handles such a dataset of varying granularities & formats.

  1. Default Number Formatting
    When you load this data, Inforiver scales each measure individually by default (and the scaling for each measure is shown in the column header). This is useful to show measures of varying granularities (e.g. Revenue & Quantity) in the same table.
    Intelligent & Automated Number Formatting for Tables
    You can change this behavior by using the number formatting pane on the menu. You may select a ‘number formatting theme’ from the dropdown and customize it further using the icons shown right beneath the dropdown. Intelligent & Automated Number Formatting for Tables
    When you expand the dropdown, you see several options. The default behavior that formats each measure individually is labeled, well, ‘Default’.
    Intelligent & Automated Number Formatting for Tables
    Let’s observe what happens when we change this selection.
  2. Unified Number Formatting
    When you change the format to ‘Unified’, Inforiver applies one fixed scale to the entire table, and moves the scaling unit display to the header. In addition, the number of decimals is reduced to one for better readability.
    Intelligent & Automated Number Formatting for Tables
  3. Native Number Formatting
    If you do not want any fancy formatting and need the numbers just as they are in the source data, select the ‘Native’ option.
    Intelligent & Automated Number Formatting for Tables
  4. Auto Number Formatting
    Auto formatting is a big favorite for many as it allows each cell to have its own scaling. Check this out. Notice how Category 1 total and Product 1 are scaled to millions while Product 9 is not scaled at all.
    Intelligent & Automated Number Formatting for Tables

Other Intelligent Number Formatting Options

Inforiver uses a monospace font (Roboto Mono) that enables the scaling units ‘k’ and ‘m’ (for thousands and millions respectively) to occupy uniform width. If this were not the case (as with most standard fonts – like Arial, Times New Roman, Segoe UI, Open Sans etc.,) the decimals in the numbers would not align properly.

Intelligent & Automated Number Formatting for Tables

Inforiver also leaves some space on the right for Product 9 so that the decimal point continues to align perfectly with the other rows.

Intelligent & Automated Number Formatting for Tables

And what more, Inforiver also shows the unscaled values in the tooltip (available upon publishing to service). This means that you can still scale values without losing the ability to look up the unscaled value using the tooltip.

Intelligent & Automated Number Formatting for Tables

You may choose one of the four options, and continue to fine-tune the format at a row, column/measure or cell-level using the icons just below the dropdown. These options include conversion to % format, scaling (thousands, millions, etc.,), attaching prefix/suffix, and decimal spaces.

Intelligent & Automated Number Formatting for Tables

Check out this example where we have used the custom options above to change the formats of specific cells. (These actions can also be performed for individual rows or columns/measures)

Intelligent & Automated Number Formatting for Tables

Number formatting with Inforiver is much quicker and a lot of fun. Go ahead & try it out today.

* * *

Resources & Links

  • Register for a beta version of Inforiver for Finance here
  • Subscribe to our blog roll to keep receiving important updates
  • Check out our upcoming webinars here
Subscribe To Our Blog

Subscribe To Our Blog

Join our mailing list to receive the latest blogs and updates from our team.

You have successfully subscribed!