The Following User Says Thank You to nieldk For This Useful Post: | ||
|
2015-08-08
, 07:17
|
|
Posts: 4,118 |
Thanked: 8,901 times |
Joined on Aug 2010
@ Ruhrgebiet, Germany
|
#152
|
Just to make sure...
In juices reports, some donations were not in €. Is the calculated total converted ?
mysql> select format(sum(total_amount * exchange_rate), 2) as totals from all_donations; +----------+ | totals | +----------+ | 3,451.43 | +----------+ 1 row in set (0.00 sec)
|
2015-08-08
, 10:44
|
Community Council |
Posts: 4,920 |
Thanked: 12,867 times |
Joined on May 2012
@ Southerrn Finland
|
#153
|
|
2015-09-01
, 07:03
|
Community Council |
Posts: 4,920 |
Thanked: 12,867 times |
Joined on May 2012
@ Southerrn Finland
|
#154
|
mysql> select date, account, format(total_amount, 2) as donation, currency, format(total_amount*exchange_rate, 2) as "sum in EUR" from all_donations order by date;+------------+---------------+----------+----------+------------+ | date | account | donation | currency | sum in EUR | +------------+---------------+----------+----------+------------+ | 2015-07-01 | PayPal | 9.46 | EUR | 9.46 | | 2015-07-01 | PayPal | 10.00 | EUR | 10.00 | | 2015-07-01 | PayPal | 10.00 | EUR | 10.00 | | 2015-07-01 | PayPal | 15.00 | EUR | 15.00 | | 2015-07-01 | Deutsche Bank | 26.82 | EUR | 26.82 | | 2015-07-02 | Deutsche Bank | 100.00 | EUR | 100.00 | | 2015-07-02 | PayPal | 47.05 | EUR | 47.05 | | 2015-07-02 | PayPal | 19.27 | EUR | 19.27 | | 2015-07-03 | PayPal | 25.00 | EUR | 25.00 | | 2015-07-03 | Deutsche Bank | 100.00 | EUR | 100.00 | | 2015-07-03 | Deutsche Bank | 50.00 | EUR | 50.00 | | 2015-07-04 | PayPal | 20.00 | EUR | 20.00 | | 2015-07-05 | PayPal | 20.00 | EUR | 20.00 | | 2015-07-06 | Deutsche Bank | 50.00 | EUR | 50.00 | | 2015-07-06 | PayPal | 150.00 | EUR | 150.00 | | 2015-07-07 | PayPal | 20.00 | EUR | 20.00 | | 2015-07-07 | PayPal | 25.00 | EUR | 25.00 | | 2015-07-08 | PayPal | 20.00 | CAD | 13.89 | | 2015-07-08 | PayPal | 95.90 | GBP | 130.15 | | 2015-07-08 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-08 | Deutsche Bank | 200.00 | EUR | 200.00 | | 2015-07-10 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-10 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-10 | PayPal | 40.49 | PLN | 9.43 | | 2015-07-10 | PayPal | 40.00 | EUR | 40.00 | | 2015-07-13 | PayPal | 30.00 | EUR | 30.00 | | 2015-07-13 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-15 | Deutsche Bank | 100.00 | EUR | 100.00 | | 2015-07-16 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-17 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-17 | PayPal | 15.00 | EUR | 15.00 | | 2015-07-23 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-24 | PayPal | 141.65 | NOK | 15.35 | | 2015-07-27 | PayPal | 48.70 | EUR | 48.70 | | 2015-07-28 | Deutsche Bank | 10.00 | EUR | 10.00 | | 2015-07-30 | Deutsche Bank | 500.00 | EUR | 500.00 | | 2015-08-03 | PayPal | 43.79 | EUR | 43.79 | | 2015-08-03 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-08-04 | Deutsche Bank | 100.00 | EUR | 100.00 | | 2015-08-04 | PayPal | 95.90 | GBP | 133.02 | | 2015-08-04 | PayPal | 100.00 | EUR | 100.00 | | 2015-08-04 | Deutsche Bank | 30.00 | EUR | 30.00 | | 2015-08-04 | Deutsche Bank | 30.00 | EUR | 30.00 | | 2015-08-04 | Deutsche Bank | 25.00 | EUR | 25.00 | | 2015-08-04 | Deutsche Bank | 994.50 | EUR | 994.50 | | 2015-08-07 | PayPal | 25.00 | EUR | 25.00 | | 2015-08-10 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-08-18 | Deutsche Bank | 25.00 | EUR | 25.00 | +------------+---------------+----------+----------+------------+ 48 rows in set (0.00 sec) mysql> mysql> select format(sum(total_amount * exchange_rate), 2) as totals from all_donations; +----------+ | totals | +----------+ | 3,496.43 | +----------+ 1 row in set (0.00 sec) mysql>
The Following 7 Users Say Thank You to juiceme For This Useful Post: | ||
In juices reports, some donations were not in €. Is the calculated total converted ?
You can still support my work by donation - click here