When I try to convert a # field to a % field, Airtable adds like two decimal points - any idea why and how to undo this?
Converting # field to % field adds 2 decimal places - how to fix?
+27The value of the underlying number is not being changed. This is part of the general relationship between decimals and percents.
A value of 96% would be a decimal number of 0.96.
Thus the number 96 would be 9600%.
You can use a formula field to divide the numbers by 100 and then copy the new values back to the percent field.
kuovonne wrote:
The value of the underlying number is not being changed. This is part of the general relationship between decimals and percents.
A value of 96% would be a decimal number of 0.96.
Thus the number 96 would be 9600%.
You can use a formula field to divide the numbers by 100 and then copy the new values back to the percent field.
Thanks so much @kuovonne! (again!)
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.