Jump to content
Sign in to follow this  
mtpaper

Currency: Exchange Rate

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 by Guest

Share this post


Link to post
Share on other sites

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

Then those three fields are the correct approach, IMHO.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.