MagicRobot Currency Conversion Example Formula Field

The following represents a formula on the MagicRobot Magic Influence Split object formula for converting currency to display on the end user’s currency:

ROUND(
(
(
(

/* This gets you the Opp’s value in the Opp’s currency using Today’s rates */
IF(
ISBLANK( Camp_Inf__Opportunity__r.{YOUROPPFIELD__c} ),0,
Camp_Inf__Opportunity__r.{YOUROPPFIELD__c}
)

*
IF(Camp_Inf__Campaign_Currency__c = Camp_Inf__Opportunity_Currency__c,
1,
(Camp_Inf__FX_Live_Opp_to_Org__c * (1/Camp_Inf__FX_Live_Campaign_to_Org__c))
)

/* NOW we exchange the Opp’s value to the dated or Currency */

*
(1/
IF(ISBLANK(Camp_Inf__FX_Live_Opp_to_Org__c),1,
IF(Camp_Inf__FX_Use_Live_or_Dated_Rate__c = “Dated”,
Camp_Inf__FX_Dated_Opp_to_Org__c,
Camp_Inf__FX_Live_Opp_to_Org__c
)
)
)

/* Now we convert from the Org currency back to to the Campaign Currency for display */

*
Camp_Inf__FX_Live_Campaign_to_Org__c

)

/* NOW we divide by the total number of influence splits */

*
Camp_Inf__Number_of_Opps_Influenced__c
)
+
0.000000009),7)