How can I see Actual Revenue in Advanced Analytics in Project Currency not Company Currency?

Question

I have a project using Euros but when I look at Actual Revenue data in Advanced Analytics, I see the same value but they are listed in GBP. Why?

Answer

Advanced Analytics reports in company currency, not project currency. If you have a project using a currency other than your company currency, you can add a formula based on the currency conversion rate to a dashboard that will allow you to see Actual Revenue values in the project currency.  To do so, use the following calculation and adjust the currency conversion rate based on the current conversion rate between your company currency and the project currency. 

To convert company currency to project currency:

SUM( [Project Actual Revenue] )*1.3

Please note 1.3 is the conversion rate used here in this example formula. This may not be the rate used in your formula as it depends on the current currency conversion rate between the currencies you are working with.