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
CarlosSantiago's avatar
CarlosSantiago
Qrew Trainee
9 years ago
FYI - I was using this formula to display a discount (negative number) and it was dropping out the thousands place (i.e. instead of showing "-$1,500.00" it was showing "-$500".  The way the Thousands variable is set up, it kicks in if the number is greater than 1,000.  Well, it's also true if it's less than -1,000.  I added the Abs function to get it to work:

var text Thousands =
 If(Abs($Value)>=1000,ToText(Int(Abs($Value)/1000)));