JackWoods

4 years agoQrew Trainee

# Rich Text Formula Field - Comma for Currency #?

Hey Community,

I'm using a Rich Text Formula field called NPV(Color) to show the NPV value in red when it's negative. It's working well but now I just need to format it - I can't seem to add commas to the currency number in the formula field. Could you help?

the formula is below.

If([NPV]<=0,"<font color=\"red\">$"&[NPV]&"</font>","<font color=\"black\">$"&[NPV]&"</font>")

------------------------------

Jack Woods | Low Code 4 Lyfe

------------------------------

I'm using a Rich Text Formula field called NPV(Color) to show the NPV value in red when it's negative. It's working well but now I just need to format it - I can't seem to add commas to the currency number in the formula field. Could you help?

the formula is below.

If([NPV]<=0,"<font color=\"red\">$"&[NPV]&"</font>","<font color=\"black\">$"&[NPV]&"</font>")

------------------------------

Jack Woods | Low Code 4 Lyfe

------------------------------