Add Euro symbol or the letters EUR to the left of dollar amount in a formula (Part 2)

All those gyrations were to get a text string which looks how you want it. It is not a number. The last thing you would want to to is to try to parse out the numeric portion.

You should just make a formual numeric like



var number PriceToUse = Case([Price List to Use],
"US List Price", [US List Price],
"Asia Dist Price", [Asia Dist Price],
"Asia List Price", [Asia List Price],
"EUR Dist Price", [EU Dist Price],
"EUR List Price",  [EU List Price]);

[Quantity] * $PriceToUse