Corporate currency conversion in OTBI report
We have multi currency enabled in application.
In the Opportunity UI user's select the currency as required and go through the pipeline process to book/close opportunity.
We have an OTBI report to show the Total revenue of each Opportunity.
In report user wants to see two columns,
- first column with the revenue amount of Opportunity in the currency selected on the opportunity (for example in EUR, USD)
- second column with converted amount as per the corporate currency set in the application (GBP)
Is there way to achieve this in OTBI report.
Content (please ensure you mask any confidential information):