![]() I have advanced but there is more work to wrote You could make a running total using the SUM function in your SQL query, e.g. This has now enabled me to create three queries, one for each currency where I have added a column ‘Net’ * ‘exchangeRate’ This gives me the value of each transaction in Euros, These work perfectly, so as said “impossible” is a strong word!! I am making now working on a way to combine all the totals to give me a value for the “paypal” account in Euros, I would like to somehow use a form where I enter the date and in three other columns I have the sum of all transaction up to that date, this is very important to me as it enables me to control my calculations, Hi, This is not a full answer but I Have advanced! I have changed my “paypal” table to include an “ID” column as joint primary key along with “NDT” I have also added an exchange rate column, this is calculated in the Calc document and then imported as data, I have deleted “time” column as this is no longer needed. OOOk below is a screen shoot of the calc paypal table and a copy of the db I am trying to create for my accounts Thanks in advance for anybody who takes a look Then in 2017, it announced it would repurchase another 5B in common stock (PayPal Holdings, Inc., 2019). When I have enough points I will add a screen shot of the calc table and a copy of the db to Help. ![]() At the moment I have set “Date” “Time” and “Transaction number” as primary keys, This can be changed and a unique ID column added if needed. I expect to use one query for each currency then a further query to bring all the information together. I want to create a query that I can use later, which calculates the exchange rate for a given currency and records this for each payment above. It worked very well but this and other formula in the document made it very heavy and slow.ĭate | Heure | Type | Devise |Avant commissionĢ8/07/17|10.03 |conversion | USD | -536.25Ģ8/07/17|10.03 |conversion | EUR | 410.25ģ0/0/7/17|08.00|Bank trans| EUR | -400.00 =IF($I1155=“USD”,IF(OR(G1155=“Conversion de devise initiée par l’utilisateur”),$L1156/$L1155*-1,$T1156+0),T1156+0)Īt the end of the table I had an approximate value for the exchange rate because the formula looked at the result of the cell below. ![]() With calc this was easy as i had a table and in one column for each currency I had this formula For my accounts I need to know the value of each transaction in EUR, the value of which is decided when I exchange the currencies two times a week, this is always after I have been paid. Hi again! I am back with the same question but with more information about what I have and What I need, I am looking for pointers to help me solve this (ie tutorials forums etc) I have a table called PayPal which I down load as a csv file and then copy into the db table, I live in france so my Home currency is EUR, i sell in EUR, USD and GBP. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |