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

Question

My company's default currency is GBP. I have a project using Euros and when I look at the Actual Revenue in Advanced Analytics, I see values in GBP. Why?

Answer

Advanced Analytics reports in company currency, not project currency. If you have projects using a currency other than your company currency, you can update formulas to include the currency conversion rate you have set up in Forecast.

To see Actual Revenue values in the project currency, you can use this formula:

([Total Project Actual Revenue]) * ([Total Project Currency Exchange Rate])