Hello, we are implementing Odoo since a couple of months. So still new to some of the tricks.
Our company is trading in three different currencies, and we have these currencies set up in Accounting/Currencies with their exchange rates.
In the sales module, in pivot view, I can add the "Currency Rate" as a metric, but the displayed numbers are only correct on the level of the individual sales order number.
Any summary does not show the average of the individual currency rates, but the sum of it. This is not what I need.
If I have 10 Transactions at a 0.8 currency rate, these transaction have a currency rate of 0.8 and not of 8, as it is displayed.
Thanks a lot!
While your solution works, I found an easier option.
I found that after exporting the pivot to a spreadsheet, I get the option to edit the pivot parameters and set "Aggregate by" for the currency rate from "sum" to "average".
So, for reporting purposes, this works well.
Thank you!