Currency convert field

[kfok]

My FM solution has a field containing amounts of different currency, e.g. A$100, US$200, C$500. I want to convert all of them into US$ by creating a calculated field. Any ideas?

[comment]

Start by breaking the information into two separate fields: Currency (text) and Amount (number). Then define a table of rates with two fields: Currency (text) and Rate (number). Define a relationship:

YourTable::Currency = Rates::Currency

Finally, in YourTable define a calculation field (result is number) =

Amount * Rates::Rate

Don't forget to include a rate of 1 for US$.

EDIT: seeing this is version 6, when I say "table", I mean "file".

Edited January 21, 2006 by Guest

[Lee Smith]

This file by Christian Jaeger, that I found in the Sample Files Topic Area maybe of help Link

Lee

[comment]

It looks like there's no file there...

[Lee Smith]

Dam*, conversion got me again.

Here it is again.

I fixed the other link too.

Euro_Rates.zip

Edited January 21, 2006 by Guest
link repaired