Forum Discussion

JeffRogerson's avatar
JeffRogerson
Qrew Cadet
11 years ago

Numeric Field Formatted For Currency Used In A Text Formula Field Looses Formatting?

So a numeric field formatted for currency looses its currency formatting if picked up as an element in a text formula field? (ie looses "$" and more crucial any decimals?) So if your numeric field...
Formulas and functions
Tables and fields
LauraLaura1's avatar
LauraLaura1
Qrew Member
8 years ago
Hey there! I have some currency fields that will include dollar amounts in the millions, requiring more than one comma ($3,000,000.00 for example). Anyway there is something I can add to the above formula to make this work for those values?