Losing Number Format in Rich Text Formula
I found a few references to my issue in old posts but the links all seem to be dead. I'm trying to display the value of a currency field [PO Subtotal] in a rich text formula field. The number displ...
Forum Discussion
With some slight modification, that worked perfect. Thank you so much for the quick reply Mark.
Here's the mod I made:
var text txtRounded = ToFormattedText(Round([yourvalue],0.01),"comma_dot");
------------------------------
Matt Hardy
------------------------------
Here's the mod I made:
var text txtRounded = ToFormattedText(Round([yourvalue],0.01),"comma_dot");
------------------------------
Matt Hardy
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendOk great, ya that must have been one to use for Percentages.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------