Forum Discussion

AmyGosz2's avatar
AmyGosz2
Qrew Cadet
6 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
6 years ago
This tested OK to do background shading and drop the decimals

var number Price = Round([Annual Surcharge Total]) ;
var text FormattedNumber =
"$" & 
ToFormattedText($Price,"comma_dot",3); 

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