• confidexbill
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

I have the following formula used to convert a value to EURO:

"EUR " & IF(  NOT(CONTAINS(TEXT(CurrencyIsoCode), "EUR")),  TEXT(Amount*CASE(TEXT(CurrencyIsoCode), "USD", 0.677354 , "CHF", 0.9, 1)),TEXT(Amount))

 

I would like the returned result to be formatted with a comma for the thousands separator.

For example: 25,000

 

Changing the return type of the formula as currency does not work. I get the following error message:

Error: Invalid Data.

Formula result is data type (Text), incompatible with expected data type (Currency).

 

Any ideas?