2 Replies Latest reply on Feb 19, 2016 2:01 PM by mjbenun

    Calculation to format a currency field

    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!