cancel
Showing results for
Search instead for
Did you mean:
Administrator

Currency miscalculation

Good morning community,

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?

Thank you very much for your help.

Best regards

1 ACCEPTED SOLUTION
Solution Specialist

Is it possible that the value (USD/Euro) is actually 0.8632.....?

This will give the results you see in the column Valor.

Jori

If I answered your question, please mark it as a solution to help other members find it more quickly.

2 REPLIES 2
Solution Specialist

Is it possible that the value (USD/Euro) is actually 0.8632.....?

This will give the results you see in the column Valor.

Jori

If I answered your question, please mark it as a solution to help other members find it more quickly.

Administrator

Hello @Jori,

thank you very much for responding so quickly.

Indeed, the value with 4 decimal places is 0.8632 and coincides with the amount of the calculation of the formula.

Thank you very much for your help!! What a mistake!

Best regards

Helpful resources

Announcements

Launching new user group features

Learn how to create your own user groups today!

Check it Out!

Click here to read more about the November 2021 Updates!

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors