How are they wrong?Renato wrote:Hello Nikolay
The results from the current month are wrong.
Favorite account balance history
Moderator: Renato
-
- Super User
- Posts: 72
- Joined: Thu Dec 11, 2014 8:40 am
- Are you a spam bot?: No
Re: Favorite account balance history
-
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Favorite account balance history
for example:
a) an account that has 2 months zero, suddenly has a balance of 248840.88 in the current month.
b) the exchange rate on foreign currency accounts will not be considered.
a) an account that has 2 months zero, suddenly has a balance of 248840.88 in the current month.
b) the exchange rate on foreign currency accounts will not be considered.
Renato Forum Administrator
-
- Super User
- Posts: 72
- Joined: Thu Dec 11, 2014 8:40 am
- Are you a spam bot?: No
Re: Favorite account balance history
Hi Renato,
I'm back in the country and just tried this latest report posted by Nikolay and i get the same results as you for the current month. Orders of magnitude larger than previous months.
I'll leave it for Nikolay to fix, the HTML side has changed back to the default formatting.
I'm back in the country and just tried this latest report posted by Nikolay and i get the same results as you for the current month. Orders of magnitude larger than previous months.
I'll leave it for Nikolay to fix, the HTML side has changed back to the default formatting.
-
- Super User
- Posts: 72
- Joined: Thu Dec 11, 2014 8:40 am
- Are you a spam bot?: No
Re: Favorite account balance history
Here is my latest report, but it does NOT have the latest features from this week from Nikolay.
It has the totals you asked for in the other thread, and growth.
It has the totals you asked for in the other thread, and growth.
You do not have the required permissions to view the files attached to this post.
-
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Favorite account balance history
Hello sterling
The formation like me, however, if an account goes to zero during this time, then it is not listed / considered.
Furthermore, the foreign currencies are not converted.
In addition, there is the problem that in the foreign currency accounts of the exchange rate would have to be taken from the end of the month.
Thus, Total and the Growth are unusable.
The formation like me, however, if an account goes to zero during this time, then it is not listed / considered.
Furthermore, the foreign currencies are not converted.
In addition, there is the problem that in the foreign currency accounts of the exchange rate would have to be taken from the end of the month.
Thus, Total and the Growth are unusable.
Renato Forum Administrator
-
- Super User
- Posts: 72
- Joined: Thu Dec 11, 2014 8:40 am
- Are you a spam bot?: No
Re: Favorite account balance history
I intentionally dont consider an account with 0 balance.
In the SQL you can change line 203 from
to
You can also change the Santander-Joint to be an account you dont want listed.
In the SQL you can change line 203 from
Code: Select all
where a.STATUS = 'Open' and a.FAVORITEACCT <> 'blahTRUE' and a.ACCOUNTTYPE!='Credit Card' and a.ACCOUNTNAME<>'Santander-Joint' and BalanceNow>0
Code: Select all
where a.STATUS = 'Open' and a.FAVORITEACCT <> 'blahTRUE' and a.ACCOUNTTYPE!='Credit Card' and a.ACCOUNTNAME<>'Santander-Joint'