I am trying to pull together a report for commissions by Partner where I can show the transaction & commission amounts in the local currency (eg USD) as this is what the partner is paid in. But as Base Currency set to GBP this is all I can pull through which is the calculated conversion.
I tried to pull through Exchange Rate to convert back but there are Decimal Precision issues where an exchange rate of 8 decimal places is rounded to 2 which is clearly no good. I even tried to create a custom decimal field that would source and "mirror" the full exchange rate but this is rounded to 4 decimal places (for some reason???). This is still not accurate enough.
I need to be able to either:
1. Pull through the transaction and commission values in the currency of the transaction
OR
2. Be able to pull through the entire exchange rate to use in a formula field.
I seen a few posts about decimal precision but any help within Reports would be good.