Currency: Exchange Rate

[mtpaper]

Hello

I'm compiling a table that has a number field.

However, sometimes it will be US$ and sometimes some other currency.

I'm not sure of the best way to handle this, but I'm thinking that I need to add 3 fields:

Text: Currency type

Numeric: Exchange Rate

Calculated: Amount * Exchange Rate

1. Do you have any alternative suggestions?

2. with the above structure, how do I make Currency Type have a default value of "US$", and the Exchange Rate have a default value of "1"

Thank you -

Marion

[comment]

Should the exchange rate be fixed at the time of entry, or should it update dynamically?

For default values use the auto-entry options in the field definitions.

[mtpaper]

Hi

I will enter a fixed exchange rate when I enter the data.

I will look at Auto-Entry options in the field definitions - thanks for the push in the right direction

Marion

EDIT: Duh. that was so easy and obvious. I've looked at that window 100s of times, but didn't make the mental connection.

Edited May 3, 2009 by Guest

[comment]

I will enter a fixed exchange rate when I enter the data.

Then those three fields are the correct approach, IMHO.