I have an issue with the formatting of percentage numbers.
We are using a field "% Parent". The value for this field is imported with four decimal digits, i.e. in the form "52.5423" and then rounded/shown in OrgPlus to/with 2 digits ("52.54"). This field is formatted as Number => Percentage => two decimal digits.
The issue I have is that numbers above 99.99% are rounded to 100%, e.g. "99.9981" is shown as "100%". To avoid this, I would like to implement a function that transforms the "% Parent" value as follows:
- Values between 0.0000 and 99.9900 shall be shown in the defined format with 2 digits (e.g. 52.5423 as 52.54)
- Values between 99.9900 and 99.9999 shall be shown as ">99.99%"
- 100.0000 values shall be shown as "100%" (without decimal digits).
This could be achieved by enhancing the formatting capabilities of single fields, i.e. depending on the value in a field it is formatted differently (or a different value is inserted in such field).
I am a aware that such goal could be achieved by using conditional formatting. However, this is not very comfortable as you have to create for each defined conditional format two additional conditional formats. We are currently using three different kind of conditional formats. By using this solution, we would then have 12 conditional formats and every time you want to change something you have to change it in all 12 conditional formats.
Thanks for taking this into consideration for one of the next releases.
(this has request has been sent / asked to support with e-mail of Jan 13, 2010)