Hi Ceraulo,
I suspect one value comes from obtaining the total in EUR and converting it to USD using the latest conversion rate (which is updated daily), and the other would be the sum of individual items' EUR prices possibly converted at a different rate each (if they were entered on different days, I guess) and only then added together as USD values, like in the example below:
Calculation 1: €300 + €700 = €1,000 --[x1.07]--> $1,070
Calculation 2: (€300 --[x1.05]--> $315) + (€700 --[x1.06]--> $742) = $1,057
***
As per the Product Documentation:
Whenever you perform a conversion, it uses the latest conversion rates. Therefore, calculations can potentially yield unexpected results. For example:
- Different currency values can have different rates applied to them while storing the reference currency value. Therefore, aggregation can combine values at different rates and convert back at another rate.
- A filter value is converted at current rates while the values it filters in the database can be converted at different rates. A filter for $100 at today's rate can match a value of $99 obtained at yesterday’s rates.
Product documentation: Default currency conversions
Hope this helps!
Best wishes,
Lukasz
