AnsweredAssumed Answered

Currency conversions

Question asked by danielle-gwa on Aug 29, 2012
Latest reply on Aug 29, 2012 by comment

Currently we have a database containing wind turbine part details. Within wach part record there may be a price field. Dependant on where we buy the part there will of course be a range of currencies that the price may be in (e.g. Euros, Pounds sterling, US dollars, Danish Krone, etc).

 

I want to create a report of all the parts, but show an overall cost for the parts in one currency, Euros. How would i go about showing what all the part prices are in Euros??

 

 

 

Maybe i need to create a calculation field that says

If in Pounds sterling, divide by 0.7918 and multiply by 1

 

If in Euros, do nothing

 

If in US Dollars, divide by 1.2557 and multiply by 1

 

 

Then i would need to keep manually adjusting the conversion rate.

 

 

 

 

 

Can someone please advise me on the best way to do this if different from my suggestion????

 

Thank you

Outcomes