Currency conversion calculation
I have a script which downloads the currency rate into a global field. I thought that global fields would be the same repeated through all records but I can see that I was wrong.
I wanted to reference this global field in a calculation that would update prices for me in different currencies.
What is the best way to approach such a calculation?