Summary tables and Currency
Hi all, I have a Summary table which rolls up the totals of data that's added to a table called 'Opportunity Products'. Each line of data will have a 'Total price' added to it, but the addition dep...
Forum Discussion
Hi Mark,
Ideally, convert them all into a common currency for this purpose (GBP) but not alter how they are originally added into the tables if that makes sense?
Thanks,
Michael
------------------------------
Michael Bretton
------------------------------
Ideally, convert them all into a common currency for this purpose (GBP) but not alter how they are originally added into the tables if that makes sense?
Thanks,
Michael
------------------------------
Michael Bretton
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendWell the super low tech way is simply to create a table of exchange rates with three records in it. The key field of the table will be the currency code and you would have entries for the conversion factor. The conversion factor for GPB would be 1.000, the US rate would be about 0.75 and the conversion for the EU would be about 0.89.
He would make a relationship between the currency exchange table and your transactions table to look up the exchange rate and then have a formula to calculate the Total Price multiplied by the exchange rate.
Everything would be converted to a common currency.
The other factor to consider is whether you were looking to make the conversion at the current exchange rates or do you want to freeze them at the time the records were created. If you want to freeze them at the time that the records were created then you can use what is called a snapshot field. (see link for Help) This will be an additional numeric field Which will hold the frozen or snapshot it value of that exchange rate at the time the transaction record was created.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
He would make a relationship between the currency exchange table and your transactions table to look up the exchange rate and then have a formula to calculate the Total Price multiplied by the exchange rate.
Everything would be converted to a common currency.
The other factor to consider is whether you were looking to make the conversion at the current exchange rates or do you want to freeze them at the time the records were created. If you want to freeze them at the time that the records were created then you can use what is called a snapshot field. (see link for Help) This will be an additional numeric field Which will hold the frozen or snapshot it value of that exchange rate at the time the transaction record was created.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------