A new Auto option is available in the number format abbreviation picker. ![]()
If your data spans hundreds to millions in the same field, picking a fixed K, M, or B means some values always look off. Set abbreviation to Auto in your number format configuration, and Holistics picks the right unit per value at render time - so $800, $250K, and $12M can all display correctly in the same column.
How it works
Set the abbreviation to Auto in your format configuration for number (normal/currency). The system picks the abbreviated unit based on each valueβs magnitude:
- Under 1,000: displayed as-is (e.g.,
800) - 1,000 - 999,999: abbreviated as K (e.g.,
250K) - 1,000,000 - 999,999,999: abbreviated as M (e.g.,
12M) - 1,000,000,000+: abbreviated as B (e.g.,
1.2B)
Learn more
- Number format in GUI: Data Formats | Holistics Docs (4.0)
- Number format in AML: Number Format | Holistics Docs (4.0)