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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
11 years ago
My current tightest formula is this one





var number Value = Round([currency number],0.01);

var text Decimals = "." & Right(ToText(Int($value * 100)),2);

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

var text Hundreds=Right(ToText(Int($Value)),3);

If($Value=0,"$0.00",

If($Value<0, "- ")

&

"$" & List(",",$Thousands,$Hundreds) & $Decimals)