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
JamesBlackford's avatar
JamesBlackford
Qrew Member
6 years ago
Would like this formula to show whole dollars without the decimals.  Output should show something like:  $1,234 or $12,456 or $564

Thx


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"
);