Forum Discussion

JulieMeeker's avatar
JulieMeeker
Qrew Cadet
6 months ago

Trying to format with 2 decimal places

I have a Formula Rich Text field to display a grand total.  If the cents end in 0 like .10 it drops the final 0.  Here is my formula "<p style=font-size:14pt;color:red;><b>"& "$" &        ToFormat...
formulas
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 months ago

This is a formula from Sharon Faust, the QuickBase Junkie

 

var text SALES = If(IsNull([Total]),"","$" &
Part(ToFormattedText(abs([Total]),"comma_dot",3),1,".") & "." &
PadRight(Part(ToText(abs([Total])),2,"."),2,"0"));

var text COL = If([Total]<0,"Red");

"<span style='" &
  "color:" & $COL & ";" &
  "display:block;" &
  "text-align:right;'>" &
  $SALES &
"</span>"