I have a formula(Checkbox) field on the Opportunity object, which shows TRUE, when Some_Value__c (formula(Currency)) field >= 6000$:
Some_Value__c / CURRENCYRATE(TEXT(CurrencyIsoCode)) >= 6000
Default currency in our org is USD, but we have records with other currencies. We also have enabled Advanced Currency Management is enabled. Salesforce use those currencies, which could be updated manually in Currencies (Setup -> Company Profile -> Manage Currencies). But in the Opportunity records in UI, currency rate values are always get from Dated Exchange Rates ((Setup -> Company Profile -> Manage Dated Exchange Rates)).
So we have different values because of different rate values. As I know, there is no ability inSalesforce to use Dated Exchange Rates values in Formula fields.
So the question is do we have any ability to use Dated Exchange Rates values to have actual values in Opportunity records?