How are they wrong?Renato wrote:Hello Nikolay
The results from the current month are wrong.
Favorite account balance history
Moderator: Renato
Re: Favorite account balance history
- Renato
- 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
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.
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.
- Attachments
-
- History Savings.grm
- (3.07 KiB) Downloaded 689 times
- Renato
- 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
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'