Exploring TM1 - a Chartertech Company
Search
Close this search box.

Formatting a Cube to Display Thousands

I opened a cube the other day that had been created by someone else and was confounded for a short while about how it was formatted to display thousands, rather than units.

Select the Measures Dimension, then tight click and Edit Element Attributes. Select the element you want to set, click the format button, choose Custom and paste #,###,;(#,###,) into the Custom Style.  This will then remove the last three digits from a number before the first comma from the right. Bingo!

This then works not only for thousands, but millions etc as well.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In