+ Start a Discussion
Rakesh BoddepalliRakesh Boddepalli 

Can we use the ConvertCurrency() function in formula field .

Hi,

 

We have multi-currency enabled in our organization.

I want to have a field which shows the corporate currency equivalent of the opportunity amount field.

So trying to see if we can use the Convertcurrency() function in Formula field or not. If yes please let me know how?

 

Thank,

Rakesh B

Navatar_DbSupNavatar_DbSup

Hi,

Try the below formual as reference:

 

OR(

AND( ISPICKVAL (CurrencyIsoCode , "USD"),

ISPICKVAL( Alternative_NST_Type__c , "8k - 8pct"),

Service_Incremental_Discount__c > 8000),

AND( ISPICKVAL (CurrencyIsoCode , "EUR"),

ISPICKVAL( Alternative_NST_Type__c , "8k - 8pct"),

Service_Incremental_Discount__c > 5840),

AND( ISPICKVAL (CurrencyIsoCode , "GBP"),

ISPICKVAL( Alternative_NST_Type__c , "8k - 8pct"),

Service_Incremental_Discount__c > 5160))

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.