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)