Skip to main content
Topics#Data ManagementRochelle Montney's Question
Rochelle Montney asked in #Data Management
Feb 4, 2014, 9:02 PM

I want to use AUD currency, regardless of user defalut currency, in a formula within a workflow.

We use multiple currencies.  I want to create a formula in a workflow that multiplies an RV% to a HW cost then have it determine if it's greater than $250,000 AUD.  I have the basic formula done, however, we have users that have a different currency default (USD, CAD, MYR, etc.). So how do I get the system to know to first ALWAYS convert the HW cost to AUD then determine if it's over the $250,000 AUD?

 

(T1_E1_RV_Pct__c * Eqmt_1_Cost_H_W_OEC__c) > 250000.00
3 answers
  1. Tom Davis
    Feb 4, 2014, 10:30 PM
    Hi Rochelle, as currency exchange rates are not available in formulas, I'm not sure that this can be done using a formula field without having another field to store either the corresponding exchange rate for AUD or a converted value field.

     

    Sorry I can't be of any more help!
Write an answer...
0/9000