Problem
I have a formula field that takes a custom number field (formatted as % with 0 decimals). I then have a formula field that converts this % to hours by multiplying by an integer. I’ve found that that field is rounding the results to the nearest whole number, which is causing some inaccuracies at the margins.
Solution Ideas
The simplest solution (for me) would be to treat % as numbers with 2(+) significant digits. Alternatively (and maybe more universally helpful), having a setting in the formula column for decimals/significant digits (instead of relying on the combination of those settings from each number field) would be helpful.
The “Number” field type allows you to set a format of the field, such as number, percent, or various currencies. Because the “Formula” field type primarily only supports numbers, the “Number” formatting should also be able to apply to the “Formula” fields.
It generally does a good job of trying to figure out what format you want based on the fields you use in the formula, but if you want to do things like a “% over/under Budget” field by dividing the “Cost” field by the “Budget” field, it displays as a decimal and cannot be formatted to a percentage. There are other scenarios where it tries to force a specific format based on what it thinks you want, but isn’t the format you need.
I’ve moved your post into this existing request which you will be happy to note, has been tagged by Asana as ‘In Development’, which means it should be coming soon!
