Forum Discussion

AmyGosz2's avatar
AmyGosz2
Qrew Cadet
7 years ago

Formula-Rich Text field dropping the currency setting from the formula field

I have a Formula Numeric field to create a 'total'. I want to take this 'total' and display it with a colored background. I set up a Formula-Rich Text field to do this. However, the Rich Text field is...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
try this

var text Price = [Annual Surcharge Total] ;
var text FormattedNumber =
"$" & 
ToFormattedText([Price],"comma_dot",3) & 
If(
  not Contains(ToText([Price]),"."),
  ".00",
  Length(Right(ToText([Price]),"."))=1,"0"
);


 "<div style=\"background-color:pink;\">"& $FormattedNumber  &"</div>"