How do GS admin's tackle currency conversion to USD?

Each record in an SFDC object could have a different currency. While in a simple list you could show each record in it local currency, doing so in an aggregated report (e.g Sum(Annual Recurring Revenue) by customer Industry) would not be meaningful unless all the values are converted to a single currency before the aggregation. 



So any aggregate query would have the currency values converted to the org's default currency. In Rules Engine, one trick would be to just add an aggregation like sum to make sure all the currency values are returned in the org's default currency. If you have included Account ID in the show field, then while the aggregation is happening, there would be only one record per account and the final result set should still be the same intended output.

Thanks - finally got around to testing this one out. First thing I notice in the rules engine is that it does correctly aggregate the USD amount. I then removed the Gainsight Connect loader for Current ARR and ran a rule to update the company Object with what you suggested. I have two observations thus far, any thoughts?...



1) The Current ARR in the summary page now shows the correct amount, but in its native currency instead of USD.



2) The mass edit scorecard report still shows the incorrect amount even though it says ARR is a lookup from the company object. I'm tempted to let this one run overnight and see if anything updates?



Pic 1:

Pic 2:

Bringing this to a Close. The way this is done is to do SUM ARR in rule setup of an existing customer info rule ->Action: Load To Customers : SUM ARR to Customer Info: ARR. 



After map Customer Info : ARR to sync to GS Connect.