Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
5 years ago

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...
Formulas and functions
JackWoods's avatar
JackWoods
Qrew Trainee
5 years ago
I understand the format and know what you're getting at. I'm not sure if I put it in correct. 

It tells me I have additional characters past my formula...

Please see screen grab is that right?

------------------------------
Jack Woods | Low Code 4 Lyfe
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Please copy and paste your code, so I can see it all and edit it.
Also please post the error message when you save.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------