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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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