Different in Total Transactions

Page 1 of 1
2 posts
Different in Total Transactions

Mukund
Super MMEX User

Posts: 22
Joined: Thu Oct 30, 2014 10:51 am
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
Re: Different in Total Transactions

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Try to exclude 'void' and future transactions and may be closed accounts.
Page 1 of 1
Who is online

Users browsing this forum: Google [Bot] and 17 guests