How to work with decimals discreetly?

[Rafael_ANEIC-PY]

Hello friends, is there a way to allow users to type in decimal values with many decimal digits, but only show a fixed amount of decimals in other places of the app without compromising the calculation precision?

Excel for example always calculates with ALL decimals that you give it, but it allows you to tweak how many decimals you want to see at any given time.

In my use case there are times i might need 5 decimals for example, but if i set all my numeric columns to allow for 5 decimals it really phucks up the column width of those columns, and when displaying those values in workflows there is what i call “numeric column type algebra”, that, well, means that whenever i use those columns in operations, the result is going to have the same amount of decimal digits. And that means i have to choose where to drop the decimals in order to display a result in a more aesthetic way.

Bonus: Explained with parrots

If parrots were decimal digits, i want users to type in:



But only display: