Forum Discussion

DonnaTroestler's avatar
DonnaTroestler
Qrew Cadet
7 years ago

Add Euro symbol or the letters EUR to the left of dollar amount in a formula

How to format a formulaic field (called "Price") to display a Euro symbol or the letters EUR to the left of a product price? This field is used to calculate the Total Price of a line item by multiplyi...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
I have a collection of formuals to change a currency numeric value to text.

Try this one

var number Value = Round([Open Amount],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);

var text Words = 
"$" & List(",",$Thousands,$Hundreds) & $Decimals;