We have a custom object and in that custom object, we have a formula field, which will display the opportunity amount... (Formula field return type is Currency) Opportunity__r.Amount
In the opportunity record the Amount is displayed in the below format:
Oppty currency Amount (User currency)
e.g: CAD xxx (USD xxxx)
Whereas in this formula field in the custom object, it just displays the user currency..in the below format
User Currency Amount
e.g:USD xxxxx
This is the case when opportunity owner view this record. If someone else views this custom object record, then displays the formula field in the below format:
OpptyOwnerCurrency Amount (Logged in user currency)
It is NOT considering the opportunity currency.
I want to show this formula field in the same format as the opportunity amount field:
CAD xxx (USD xxxx)
please suggest any workarounds for this issue..
Advanced Currency Management is not enabled.