- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
i've got the data has different currency
need to calculate the amout of money that has been received for each order in aud
how could i do that?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You need a second table that contains currency, date and exchange rate. Then you can join on currency and date to retrieve the rate for the calculation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You need a second table that contains currency, date and exchange rate. Then you can join on currency and date to retrieve the rate for the calculation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
you mean this data right?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I don't see different currencies in your post - they are all NZD.
In case you have realy different currencies, you have to look for currency rates per date -
some external data or web tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You should have dataset for currency conversion .
This should contain currency conversion rate for all currency to AUD. This dataset should have rate on every day.
Currency Conversion
DATE CURRENCY RATE
Then you should join your Transaction table to Currency Conversion based on Date and Currency find the value in AUD.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
this one right?
using left join?
and then using rate*the amount
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Left join, with your original dataset on the left. If your exchange rate table does not cover all combinations of currency&date, you have to deal with that. Best by expanding the currency table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Can you be more illustrative about two sample t-test?
Which are the two groups on you want to run t-test?