function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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.