mjbenun

Calculation to format a currency field

Discussion created by mjbenun on Feb 19, 2016
Latest reply on Feb 19, 2016 by mjbenun

 

I have a field which accepts a retail price.  I am trying to write a formula that will reference a customer field to determine what type of currency format to use.

 

Example:  Suppose retail is 14.95

 

If Customer field shows “Macy’s” it will format as $14.95. If Customer filed shows “Galeries Lafayette” it would show €14.95, if customer is “Harrods of London” it would show £14.95, etc.

 

Is there any way to do this?

 

Thanks!

 

Outcomes