Number Formatting Precision / Stop dividing by 1000
I would like to propose a feature to instead of dividing by 1,000 to show items in thousands or 1,000,000 to show numbers in millions, that this is handled by the number formatting. This is a little used feature in excel where you can apply a format to a cell with the value $32,500 to display as $32.5.
In this case the underlying value is not change, just how its represented. This bears little difference to representing the underlying value of .985 as 98.5%, but provides more flexibility on the units represented.
Comments
-
Another vote for this functionality, would be incredibly helpful.
1 -
Still waiting on this functionality would love to see this in a release to remove the need for inserting this into line item formulas. 😉
1 -
Totally agree with James on this one! Please consider adding this functionality soon!
2 -
Let there be scaling! Architects and planners agree. Thanks for your attention to this endeavor.
1 -
Yes, please! Hard to believe we have to ask for this.
1 -
This functionality would be very useful.
2 -
Anaplan any chance we can get this in a release?
0 -
This feature has existed in reports for about two years, but it isn’t available in modeling, boards, or worksheets.
0 -
That is great, but would like this to be applied at the line item level. Bonus points if we can set conditional formatting based on the size of the number, i.e. automatically convert to K, M, of B.
3 -
Totally agree with James here! Having the ability to set the number format in this way is immensely beneficial. Not only would it make the development easier, but it also helps with model audits as you won't have to sift through line item logic to see or set your number formats.
2
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!