I have a table containing the value of the currencies USD, GBP and their conversion to Euros. On the other hand, I have a table with the sales where there is a column that indicates the currency (USD, GBP or EUR), so that the amount I have is in the original currency.
I want to present all the amounts in Euros and to multiply each amount in USD and GBP I use the conversion of the currency table to create a calculated column in the sales table, with the following formula:
When I get the result, which is apparently fine, it shows me an important difference as you can see in the image above. The total in the first row should be 15,695.94 and it calculates 15,754.35. The data types are correct, both in the Sales table and in the Currencies table.
The relationships are these:
The Sales table has a field called Currency that connects to the Currency field in the Currencies table. This allows me to get to the Change field which is the one that contains the change quotient.
Through the formula that I show you, I multiply the Total column, which contains the value of the sale by the exchange quotient, to convert the amount of the sale into euros. However, the calculation is wrong.
Does anyone know what may be going on or what I'm doing wrong?