Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Feb 19, 2019

Short Number Formatting to Include Billion/Trillion

Currently, when you format a value to "Use Short Number Format," there is no way for it to display labels larger than million. 
It will show K for 000s, and M for 000,000s. 

I think it would be extremely useful for a Billion/Trillion option.

  • Attach files
  • Guest
    Reply
    |
    Feb 20, 2019

    Thank you, Tobias! That solution worked flawlessly.

  • Admin
    Tobias Lehtipalo
    Reply
    |
    Feb 20, 2019

    There are different conventions for Billions and Trillions which is why we did not add them by default. However you can add your own symbol set for short numbers under Tools > Options > Axis Formatting. Here´s what it will look like if you use the short scale with the most common abbreviation for Billions and Trillions: