Different in Total Transactions

Build and share your cool customized reports built w/ one sql, Chart.js and Lua

Moderator: Renato

Post Reply
Mukund
New MMEX User
Posts: 12
Joined: Thu Oct 30, 2014 4:51 pm
Are you a spam bot?: No

Different in Total Transactions

Post by Mukund »

Please find the attached snap shot.
Here the total no of Transactions are different (both are circled).
How to find the error (means 1 different field).

The SQL Code is :

Code: Select all

select strftime('%Y', TRANSDATE) as YEAR
    , total('01' = strftime('%m', TRANSDATE)) as Jan
    , total('02' = strftime('%m', TRANSDATE)) as Feb
    , total('03' = strftime('%m', TRANSDATE)) as Mar
    , total('04' = strftime('%m', TRANSDATE)) as Apr
    , total('05' = strftime('%m', TRANSDATE)) as May
    , total('06' = strftime('%m', TRANSDATE)) as Jun
    , total('07' = strftime('%m', TRANSDATE)) as Jul
    , total('08' = strftime('%m', TRANSDATE)) as Aug
    , total('09' = strftime('%m', TRANSDATE)) as Sep
    , total('10' = strftime('%m', TRANSDATE)) as Oct
    , total('11' = strftime('%m', TRANSDATE)) as Nov
    , total('12' = strftime('%m', TRANSDATE)) as Dec
    , (select distinct min(strftime('%Y', TRANSDATE))
        from CHECKINGACCOUNT_V1) as Min_Year
    , (select distinct max(strftime('%Y', TRANSDATE))
        from CHECKINGACCOUNT_V1) as Max_Year
from CHECKINGACCOUNT_V1 
group by year
order by year desc;
Attachments
Trans Statics.png
(277.16 KiB) Downloaded 725 times
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Different in Total Transactions

Post by Nikolay »

Try to exclude 'void' and future transactions and may be closed accounts.
Post Reply