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?