When creating a field and choosing percentage, the calculator still sees the input into that field as a number, not a percentage. For example, when I input 50%, the calculator uses that as 50 in my formulas instead of 0.5. All of my results are greatly inflated due to this mathematical error. Am I doing something incorrectly with the fields? Thanks for any help.
Thanks Max. Any ETA would be helpful since this affects the usability of the product. Calculations are inaccurate as it functions currently. Thank you,
I’ve checked with the dev team, and they’ve confirmed that the behavior you’re seeing is correct. The Format setting affects how the value is displayed in the field, but it doesn’t impact the calculation itself.
I hope that clears things up!
So, to convert percentages into numbers, you can either keep using the previous solution or simply divide the value by 100 in the calculation