Losing Number Format in Rich Text Formula

Question

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 displays but drops the number formatting I have setup on the [PO Subtotal] field, leaving me with either 1 or no decimal points depending on the situation. How can I force two decimal points in a rich text formula field? [PO Subtotal] displays with 2 decimal points outside this rich text field.I feel like I'm missing something simple but after checking the display options for every field involved in this, I'm out of ideas and above all frustrated when all the (seemingly) relevant QB Community links are broken.Below is the entire code from the rich text formula field.
"
&lt;table align=\"right\" border=\"0\" cellpadding=\"1\" cellspacing=\"1\" style=\"width:820px;\"&gt;
  &lt;tbody&gt;
    &lt;tr&gt;
      &lt;td style=\"width: 70%;\"&gt;&amp;nbsp;&amp;nbsp;&lt;/td&gt;
      &lt;td style=\"text-align: right;\"&gt;
        &lt;p&gt;Subtotal&lt;/p&gt;
        &lt;p&gt;HST (13%)&lt;/p&gt;
        &lt;p&gt;Invoice Total&lt;/p&gt;
        &lt;p&gt;Total Payments&lt;/p&gt;
		&lt;p&gt;Balance Due&lt;/p&gt;&lt;/td&gt;
      &lt;td&gt;
        &lt;p style=\"text-align: right;\"&gt;" &amp; [PO Subtotal] &amp; "&lt;/p&gt;
        &lt;p style=\"text-align: right;\"&gt;" &amp; [Tax] &amp; "&lt;/p&gt;
        &lt;p style=\"text-align: right;\"&gt;" &amp; [Total] &amp; "&lt;/p&gt;
        &lt;p style=\"text-align: right;\"&gt;" &amp; [Total Payments] &amp; "&lt;/p&gt;
        &lt;p style=\"text-align: right;\"&gt;" &amp; [Balance] &amp; "&lt;/p&gt;
      &lt;/td&gt;
    &lt;/tr&gt;
  &lt;/tbody&gt;
&lt;/table&gt;
"​------------------------------Matt Hardy------------------------------

markshnier__you · Answer

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
------------------------------

matthardy1 · Answer

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
------------------------------

markshnier__you · Answer

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
------------------------------

Forum Discussion

Losing Number Format in Rich Text Formula

Related Content

Roundup whole number

Calculating number of days between two date fields

Invoice Number Formula

Add hyphens to phone number field

Delete Formula Button Error