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...
Forum Discussion
You could also use PadRight to fill in the missing zero(s):
------------------------------
Doug Henning
------------------------------
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
Qrew Legend
Qrew LegendYes, Doug's is simpler, but mine should also do the commas, like
$1,234.56
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
$1,234.56
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Great point Mark! You can also add number comma formatting by using the ToFormattedText function:
var Number total = Round([Total Retail], 0.01);
var Text fraction = PadRight(ToText(($total - Int($total)) * 100), 2, "0");
var Text TotalRetailTextFormat = ToFormattedText(Int($total), "comma_dot") & "." & $fraction;
------------------------------
Doug Henning
------------------------------- MarkShnier__YouThx Doug,
I will add your formula to the Borg Collective knowledge.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------