Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Feb 19, 2019

RELATED IDEAS

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.

Tibco Idea.PNG
Tibco Idea.PNG
Open full size
Tibco Idea.PNG
  • Attach files
  • Guest
    Feb 20, 2019

    Thank you, Tobias! That solution worked flawlessly.

    Reply
  • Admin
    Tobias Lehtipalo
    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: 

    Skärmavbild 20...
    Skärmavbild 2019-02-20 kl. 06.38.48.png
    Open full size
    Skärmavbild 2019-02-20 kl. 06.38.48.png
    Reply
The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group, Inc. All rights reserved