Format Numeric Value 2 Decimal Places
Hello, I have a Formula Text that calculates and displays data based on the numbers users enter in two other numeric fields. Example: When a user enters a number in my Numerator and Denominator fiel...
Forum Discussion
Try the Round function:
ToText(Round($Numerator/$Denominator,0.01) & " %")
The 0.01 tells Quickbase to round to two decimal places.
- MarkShnier__You
Qrew Legend
Or else, similar to Excel, you can go to the field properties and set the number of decimal places to display. Under the covers it was still retain it's full precision, but for presentation purposes, it will only show two decimals on forms and reports..
