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
AmyGosz2's avatar
AmyGosz2
Qrew Cadet
7 years ago

THAT WORKED!! I also changed all the [Price] field names to the actual field name.
This is the final code:

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


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


Thank you so much for the quick response!