Forum Discussion

AliMohsenian's avatar
AliMohsenian
Qrew Trainee
3 years ago

0 is dropping of when the total ends in 0

We have a number field is set to 2 decimal places and works great. shows the total for the invoice and is great.  To print it all nice we added a Rich text field with a formula that shows the tota...
DougHenning1's avatar
DougHenning1
Community Manager
3 years ago
You could also use PadRight to fill in the missing zero(s):

var Number total = Round([Total Retail], 0.01);
var Text fraction = PadRight(ToText(($total - Int($total)) * 100), 2, "0");
var Text TotalRetailTextFormat = ToText(Int($total)) & "." & $fraction;​


------------------------------
Doug Henning
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
Yes, Doug's is simpler, but mine should also do the commas, like

$1,234.56


------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------