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?