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

When I put the code in, the [Annual Surcharge Total] field is highlighted in yellow with the reason "Expecting text but found number". Do I need to convert that value to a 'text' field and use the new text field? Or, change the word 'text' in the formula to 'number'?