sum up different bank account

Build and share your cool customized reports built w/ one sql, Chart.js and Lua (https://github.com/moneymanagerex/general-reports)

Moderator: Renato

User avatar
Renato
MVP MMEX User
Posts: 213
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: sum up different bank account

Post by Renato »

Hi Nikolay

Thanks, this is precisely the evaluation I needed.

However, I have in SQL
order by ACCOUNT NAME;
by
order by HELDAT,ACCOUNT NAME;
replaced.

And in html
<th class = "i18n"> Balance </th>
<th class = "i18n"> Conv rate </th>
<th class = "i18n"> Balance </th>
by
<th class = "text-right"> Balance </th>
<th class = "text-right"> Conv rate </th>
<th class = "text-right"> Balance </th>
replaced.
regards Renato use MMEX since 2009
User avatar
Renato
MVP MMEX User
Posts: 213
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: sum up different bank account

Post by Renato »

and a.accountname like 'CS%' or a.accountname like 'SG%' or a.accountname like '.%' or a.accountname like 'Spar%' or a.accountname like 'Post%'

Code: Select all

and a.accountname in( 'CS..', 'SG..' , 'Spar..', 'Post..')
list full names for all needed accounts
regards Renato use MMEX since 2009
Post Reply