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
Here is a formula that probably works to convert the number to a text string with decimals.
var text txtRounded = ToFormattedText(Round([yourvalue]*100,0.01),"none_dot");
var number wheredot=If(Contains($txtRounded,"."),Length(Right($txtRounded,".")),0);
var text fmtnbr = If($wheredot = 0, $txtRounded & ".00", If($wheredot = 1, $txtRounded & "0", $txtRounded)) ;
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text txtRounded = ToFormattedText(Round([yourvalue]*100,0.01),"none_dot");
var number wheredot=If(Contains($txtRounded,"."),Length(Right($txtRounded,".")),0);
var text fmtnbr = If($wheredot = 0, $txtRounded & ".00", If($wheredot = 1, $txtRounded & "0", $txtRounded)) ;
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------
- Ok 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
------------------------------
