If you have a numeric field set as a Percentage and enter “5” if you wish it to be 5%, it will display 500%. If you enter 0.05, then you will get 5%.
I understand the logic, but to make the user experience consistent with the field definition, the calculation should be behind the scenes, meaning that if I enter 5 meaning 5%, then Teable divides by 100 for the purposes of calculations.
Note, this is how most Teable competitors do this.
Thanks for the feedback! This has been noted and added to our backlog.
You’re right — when a numeric field is formatted as Percentage, entering “5” should intuitively mean 5%, not 500%. The current behavior requires users to enter the decimal form (0.05 for 5%), which adds unnecessary friction.
We agree that the user input should match what’s displayed, with Teable handling the /100 conversion behind the scenes — as most competitors already do. We’ll work on improving this behavior in a future update.
Appreciate you flagging this! 
Hey @alfredcoates62 , this is now live — go check it out!