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
you can try this for that last block

"<div align='right'>"
& 
Case([Price List to Use],
"US List Price",   "$" & $Words, 
"Asia Dist Price", "$" & $Words,
"Asia List Price", "$" & $Words,
"EUR Dist Price", [Euro Symbol]  & $Words,
"EUR List Price", [Euro Symbol]  & $Words)
&
"</div>