Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution.
READ ALL ABOUT IT!
- Qlik Community
- :
- All Forums
- :
- QlikView App Dev
- :
- Re: month count
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
sagaraperera
Creator
2017-07-13
01:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
month count
Dear All
Please note according to the expressions that is applied currently, the cumulative months of business done is shown.
Current expressions applied: =(max(MARKETING_DATE) - (Opening_Date))/30
Achieved result :
| M3 | M3 | M3 | ||||
| SCCOD | SCNAME | Opening_Date | YEAR | sales | No_Of_Month | Avg_Sales |
| 01 | P | 10-Nov-2014 | 2014 | 26,669 | 2 | 16,328 |
| 10-Nov-2014 | 2015 | 187,080 | 14 | 13,491 | ||
| 10-Nov-2014 | 2016 | 230,062 | 26 | 8,826 | ||
| 10-Nov-2014 | 2017 | 189,387 | 32 | 5,987 | ||
| 10-Nov-2014 | Total | 633,199 | 32 | 20,017 |
My requirement is to arrive at the number of months relevant to a particular year. Hence kindly advise me the expressions to be applied in this respect.
Required result:
| M3 | M3 | M3 | ||||
| SCCOD | SCNAME | Opening_Date | YEAR | sales | No_Of_Month | Avg_Sales |
| 01 | P | 10-Nov-2014 | 2014 | 26,669 | 2 | 16,328 |
| 10-Nov-2014 | 2015 | 187,080 | 12 | 15,590 | ||
| 10-Nov-2014 | 2016 | 230,062 | 12 | 19,172 | ||
| 10-Nov-2014 | 2017 | 189,387 | 6 | 31,565 | ||
| 10-Nov-2014 | Total | 633,199 | 32 | 20,017 |
MY SCRIPT GIVEN BELOW
LOAD BCOD,
CLA_CODE,
PRD_CODE,
POLICY_NO,
REF_NO,
DATE(floor(MARKETING_DATE)) as MARKETING_DATE,
// DATE(monthstart(MARKETING_DATE), 'MM-YYYY') as MonthYear,
MDATE,
YEAR,
MONTH,
NAME,
ME_CODE,
//TRN_DATE,
// DATE(floor(TRN_DATE)) as TRN_DATE,
DATE(Floor(MonthStart(MakeDate(YEAR,MONTH)))) as TRAN_DATE,
TRAN_YEAR,
TRAN_MONTH,
POL_PERIOD_FROM,
SCCOD,
CP,
RS,
TC,
GROSSTOT,
TYPE,
N_R_NOS1,
F_NOS2
FROM
G:\qlickviwe\Sales\SALES2014.QVD
(qvd);
LOAD DATE(STARTING_DATE,'DD-MMM-YYYY')as Opening_Date ,
SCCOD,
SCNAME,
SCADDRESS,
ME,
//BCOD,
STATUS
FROM
G:\code\Convenient_Centre_Master.xls
(biff, embedded labels, table is Sheet1$);
Pls Help
sagara
526 Views
6 Replies
kaushiknsolanki
Partner Ambassador/MVP
2017-07-13
01:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Kindly share the sample data.
Regards,
Kaushik Solanki
Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
419 Views
2017-07-13
01:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Front End / Back end?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
419 Views
sagaraperera
Creator
2017-07-13
02:02 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
| SCCOD | SCNAME | Opening_Date | YEAR | MONTH | AC_NO | BCOD | CLASS | MARKETING_DATE | Data |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 11 Nov 2014 | 2,167 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 13 Nov 2014 | 1,320 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 14 Nov 2014 | 947 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 15 Nov 2014 | 473 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 17 Nov 2014 | 947 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 19 Nov 2014 | 1,320 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 20 Nov 2014 | 473 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 21 Nov 2014 | 473 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 22 Nov 2014 | 473 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 24 Nov 2014 | 473 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 25 Nov 2014 | 542 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 26 Nov 2014 | 1,694 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 27 Nov 2014 | 542 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 28 Nov 2014 | 947 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 01 Dec 2014 | 473 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 03 Dec 2014 | 1,015 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 04 Dec 2014 | 473 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 05 Dec 2014 | 473 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 09 Dec 2014 | 2,404 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 10 Dec 2014 | 847 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 12 Dec 2014 | 1,420 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 15 Dec 2014 | 1,015 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 16 Dec 2014 | 542 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 17 Dec 2014 | 1,015 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 18 Dec 2014 | 847 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 22 Dec 2014 | 1,015 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 23 Dec 2014 | 473 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 29 Dec 2014 | 1,862 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | Total | 26,669 | ||||
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 03 Jan 2015 | 856 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 05 Jan 2015 | 1,813 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 06 Jan 2015 | 1,027 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 07 Jan 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 13 Jan 2015 | 1,027 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 16 Jan 2015 | 1,646 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 19 Jan 2015 | 2,868 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 20 Jan 2015 | 1,405 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 21 Jan 2015 | 1,813 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 23 Jan 2015 | 956 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 27 Jan 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 28 Jan 2015 | 1,027 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 29 Jan 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 30 Jan 2015 | 549 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 02 Feb 2015 | 956 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 05 Feb 2015 | 956 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 06 Feb 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 07 Feb 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 09 Feb 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 10 Feb 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 11 Feb 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 13 Feb 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 14 Feb 2015 | 3,895 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 16 Feb 2015 | 6,494 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 17 Feb 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 18 Feb 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 19 Feb 2015 | 5,737 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 20 Feb 2015 | 1,912 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 24 Feb 2015 | 549 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 25 Feb 2015 | 956 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 26 Feb 2015 | 1,813 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 27 Feb 2015 | 956 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 02 Mar 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 03 Mar 2015 | 2,531 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 04 Mar 2015 | 1,097 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 06 Mar 2015 | 956 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 09 Mar 2015 | 1,097 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 10 Mar 2015 | 2,939 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 11 Mar 2015 | 956 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 12 Mar 2015 | 1,575 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 14 Mar 2015 | 549 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 17 Mar 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 18 Mar 2015 | 549 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 19 Mar 2015 | 856 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 20 Mar 2015 | 1,983 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 21 Mar 2015 | 549 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 23 Mar 2015 | 956 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 24 Mar 2015 | 1,027 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 25 Mar 2015 | 856 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 26 Mar 2015 | 1,434 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 27 Mar 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 30 Mar 2015 | 1,813 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 31 Mar 2015 | 2,390 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 02 Apr 2015 | 1,335 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 06 Apr 2015 | 1,505 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 07 Apr 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 08 Apr 2015 | 2,531 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 09 Apr 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 10 Apr 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 11 Apr 2015 | 3,047 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 17 Apr 2015 | 1,912 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 20 Apr 2015 | 1,434 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 21 Apr 2015 | 956 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 27 Apr 2015 | 1,405 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 28 Apr 2015 | 956 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 29 Apr 2015 | 1,434 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 30 Apr 2015 | 478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 05 May 2015 | 549 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 06 May 2015 | 856 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 07 May 2015 | 956 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 08 May 2015 | 856 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 11 May 2015 | 1,097 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 13 May 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 14 May 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 15 May 2015 | 1,593 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 19 May 2015 | 856 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 20 May 2015 | 1,071 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 22 May 2015 | 1,044 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 25 May 2015 | 1,566 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 26 May 2015 | 1,071 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 27 May 2015 | 1,044 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 28 May 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 01 Jun 2015 | 1,379 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 04 Jun 2015 | 1,593 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 05 Jun 2015 | 549 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 08 Jun 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 09 Jun 2015 | 549 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 11 Jun 2015 | 1,071 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 16 Jun 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 17 Jun 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 19 Jun 2015 | 1,097 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 20 Jun 2015 | 549 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 22 Jun 2015 | 549 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 23 Jun 2015 | 1,566 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 25 Jun 2015 | 856 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 26 Jun 2015 | 1,901 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 29 Jun 2015 | 2,690 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 30 Jun 2015 | 1,566 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 02 Jul 2015 | 1,954 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 03 Jul 2015 | -1,813 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 06 Jul 2015 | 1,044 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 07 Jul 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 08 Jul 2015 | 549 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 09 Jul 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 10 Jul 2015 | 1,071 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 13 Jul 2015 | 1,619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 15 Jul 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 16 Jul 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 17 Jul 2015 | -478 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 21 Jul 2015 | 1,071 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 23 Jul 2015 | 1,619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 24 Jul 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 27 Jul 2015 | 593 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 29 Jul 2015 | 522 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 03 Aug 2015 | 593 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 05 Aug 2015 | 566 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 06 Aug 2015 | 593 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 10 Aug 2015 | 900 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 11 Aug 2015 | 593 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 14 Aug 2015 | 1,216 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 26 Aug 2015 | 566 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 31 Aug 2015 | 593 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 01 Sep 2015 | 566 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 03 Sep 2015 | 1,132 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 04 Sep 2015 | 593 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 09 Sep 2015 | 566 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 10 Sep 2015 | 566 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 11 Sep 2015 | 566 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 16 Sep 2015 | 1,159 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 17 Sep 2015 | 900 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 21 Sep 2015 | 1,211 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 22 Sep 2015 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 24 Sep 2015 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 28 Sep 2015 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 29 Sep 2015 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 01 Oct 2015 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 02 Oct 2015 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 05 Oct 2015 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 06 Oct 2015 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 07 Oct 2015 | 927 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 08 Oct 2015 | 1,185 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 09 Oct 2015 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 12 Oct 2015 | 1,185 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 20 Oct 2015 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 21 Oct 2015 | 1,211 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 22 Oct 2015 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 23 Oct 2015 | 1,211 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 28 Oct 2015 | 1,519 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 29 Oct 2015 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 03 Nov 2015 | 1,211 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 05 Nov 2015 | 927 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 06 Nov 2015 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 09 Nov 2015 | 1,185 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 11 Nov 2015 | 2,138 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 14 Nov 2015 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 16 Nov 2015 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 17 Nov 2015 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 19 Nov 2015 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 23 Nov 2015 | 6,517 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 24 Nov 2015 | 1,211 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 26 Nov 2015 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 30 Nov 2015 | 1,519 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 01 Dec 2015 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 04 Dec 2015 | 1,211 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 08 Dec 2015 | 927 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 09 Dec 2015 | 1,519 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 11 Dec 2015 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 16 Dec 2015 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 17 Dec 2015 | 2,473 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 18 Dec 2015 | 1,211 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 22 Dec 2015 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 31 Dec 2015 | 1,185 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | Total | 187,080 | ||||
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 04 Jan 2016 | 1,248 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 11 Jan 2016 | 1,621 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 12 Jan 2016 | 1,823 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 14 Jan 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 18 Jan 2016 | 1,524 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 19 Jan 2016 | 1,804 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 20 Jan 2016 | 1,777 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 21 Jan 2016 | 3,920 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 22 Jan 2016 | 3,328 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 25 Jan 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 26 Jan 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 27 Jan 2016 | 2,880 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 28 Jan 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 01 Feb 2016 | 2,709 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 02 Feb 2016 | 1,524 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 05 Feb 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 08 Feb 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 09 Feb 2016 | 1,830 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 10 Feb 2016 | 2,396 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 11 Feb 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 12 Feb 2016 | 1,524 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 13 Feb 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 15 Feb 2016 | 1,211 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 16 Feb 2016 | 2,117 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 17 Feb 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 18 Feb 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 19 Feb 2016 | 2,704 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 20 Feb 2016 | 1,804 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 23 Feb 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 24 Feb 2016 | 1,238 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 25 Feb 2016 | 2,112 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 26 Feb 2016 | 2,449 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 27 Feb 2016 | 1,185 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 29 Feb 2016 | 927 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 01 Mar 2016 | 1,185 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 02 Mar 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 03 Mar 2016 | 1,211 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 04 Mar 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 07 Mar 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 08 Mar 2016 | 1,185 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 09 Mar 2016 | 1,695 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 10 Mar 2016 | 1,777 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 11 Mar 2016 | 1,519 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 17 Mar 2016 | 3,608 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 23 Mar 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 24 Mar 2016 | 5,951 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 25 Mar 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 28 Mar 2016 | 1,185 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 30 Mar 2016 | 2,396 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 31 Mar 2016 | 1,103 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 04 | CO22 | MOTOR_TP | 04 Apr 2016 | 592 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 04 | CO22 | MOTOR_TP | 05 Apr 2016 | 1,804 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 04 | CO22 | MOTOR_TP | 07 Apr 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 04 | CO22 | MOTOR_TP | 11 Apr 2016 | 2,704 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 05 May 2016 | 629 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 06 May 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 12 May 2016 | 650 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 13 May 2016 | 2,827 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 16 May 2016 | 629 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 17 May 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 22 May 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 25 May 2016 | 1,224 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 28 May 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 03 Jun 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 06 Jun 2016 | 2,382 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 07 Jun 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 14 Jun 2016 | 2,575 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 15 Jun 2016 | 5,179 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 16 Jun 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 23 Jun 2016 | 990 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 24 Jun 2016 | 1,191 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 29 Jun 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 12 Jul 2016 | 3,680 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 14 Jul 2016 | 1,499 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 15 Jul 2016 | 1,191 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 20 Jul 2016 | 3,372 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 21 Jul 2016 | 2,382 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 22 Jul 2016 | 1,191 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 27 Jul 2016 | 1,787 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 28 Jul 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 29 Jul 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 05 Aug 2016 | 990 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 08 Aug 2016 | 1,787 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 09 Aug 2016 | 2,489 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 11 Aug 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 12 Aug 2016 | 1,191 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 16 Aug 2016 | 1,191 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 18 Aug 2016 | 1,191 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 19 Aug 2016 | 1,191 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 22 Aug 2016 | 596 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 24 Aug 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 26 Aug 2016 | 1,560 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 29 Aug 2016 | 3,212 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 30 Aug 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 05 Sep 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 06 Sep 2016 | 2,179 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 09 Sep 2016 | 2,593 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 14 Sep 2016 | 1,560 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 15 Sep 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 20 Sep 2016 | 6,628 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 23 Sep 2016 | 1,238 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 26 Sep 2016 | 1,856 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 27 Sep 2016 | 1,238 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 05 Oct 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 06 Oct 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 07 Oct 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 11 Oct 2016 | 1,238 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 13 Oct 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 14 Oct 2016 | 4,449 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 18 Oct 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 19 Oct 2016 | 1,238 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 20 Oct 2016 | 1,856 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 21 Oct 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 24 Oct 2016 | 619 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 27 Oct 2016 | 1,856 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 31 Oct 2016 | 3,739 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 01 Nov 2016 | 1,499 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 03 Nov 2016 | 2,489 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 04 Nov 2016 | 4,189 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 07 Nov 2016 | 1,499 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 09 Nov 2016 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 11 Nov 2016 | 3,183 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 15 Nov 2016 | 1,704 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 16 Nov 2016 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 18 Nov 2016 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 21 Nov 2016 | 3,183 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 22 Nov 2016 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 23 Nov 2016 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 25 Nov 2016 | 3,628 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 30 Nov 2016 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 01 Dec 2016 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 02 Dec 2016 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 05 Dec 2016 | 1,889 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 06 Dec 2016 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 07 Dec 2016 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 09 Dec 2016 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 14 Dec 2016 | 1,704 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 15 Dec 2016 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 19 Dec 2016 | 5,756 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 20 Dec 2016 | 1,499 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 21 Dec 2016 | 2,553 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 27 Dec 2016 | 3,183 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 29 Dec 2016 | 3,402 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 30 Dec 2016 | 1,704 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 31 Dec 2016 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | Total | 230,062 | ||||
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 03 Jan 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 04 Jan 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 05 Jan 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 06 Jan 2017 | 2,518 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 11 Jan 2017 | 2,998 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 12 Jan 2017 | 1,924 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 16 Jan 2017 | 9,329 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 18 Jan 2017 | 2,779 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 20 Jan 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 21 Jan 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 23 Jan 2017 | 3,203 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 24 Jan 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 25 Jan 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 26 Jan 2017 | 2,129 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 27 Jan 2017 | 1,924 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 30 Jan 2017 | 3,183 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 01 Feb 2017 | 1,924 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 02 Feb 2017 | 3,183 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 03 Feb 2017 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 06 Feb 2017 | 1,889 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 07 Feb 2017 | 1,704 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 08 Feb 2017 | 1,889 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 09 Feb 2017 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 13 Feb 2017 | 4,052 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 14 Feb 2017 | 1,704 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 16 Feb 2017 | 1,889 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 20 Feb 2017 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 21 Feb 2017 | 1,889 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 22 Feb 2017 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 23 Feb 2017 | 3,847 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 24 Feb 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 25 Feb 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 27 Feb 2017 | 1,889 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 28 Feb 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 01 Mar 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 02 Mar 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 03 Mar 2017 | 7,030 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 06 Mar 2017 | 3,388 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 07 Mar 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 08 Mar 2017 | 4,017 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 09 Mar 2017 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 10 Mar 2017 | 5,516 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 14 Mar 2017 | 3,408 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 15 Mar 2017 | 2,758 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 20 Mar 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 21 Mar 2017 | 3,148 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 22 Mar 2017 | 1,704 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 23 Mar 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 24 Mar 2017 | 1,889 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 27 Mar 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 28 Mar 2017 | 2,518 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 29 Mar 2017 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 30 Mar 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 31 Mar 2017 | 5,926 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 03 Apr 2017 | 6,401 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 05 Apr 2017 | 2,773 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 06 Apr 2017 | 1,889 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 07 Apr 2017 | 1,075 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 11 Apr 2017 | 7,850 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 21 Apr 2017 | 6,775 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 24 Apr 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 25 Apr 2017 | 3,183 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 26 Apr 2017 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 27 Apr 2017 | 1,075 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 28 Apr 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 02 May 2017 | 1,889 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 03 May 2017 | 1,075 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 05 May 2017 | 2,553 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 08 May 2017 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 09 May 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 15 May 2017 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 16 May 2017 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 17 May 2017 | 2,334 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 18 May 2017 | 1,259 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 19 May 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 23 May 2017 | 2,553 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 24 May 2017 | 1,924 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 25 May 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 26 May 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 30 May 2017 | 2,553 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 31 May 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 01 Jun 2017 | 1,499 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 02 Jun 2017 | 1,704 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 05 Jun 2017 | 3,812 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 07 Jun 2017 | 1,889 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 12 Jun 2017 | 1,075 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 13 Jun 2017 | 1,924 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 14 Jun 2017 | 2,963 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 15 Jun 2017 | 630 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 16 Jun 2017 | 1,889 | |
| SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | Total | 189,387 | ||||
| SC019 | Piriwena Juntion | 10-Nov-2014 | Total | 633,199 |
419 Views
kaushiknsolanki
Partner Ambassador/MVP
2017-07-13
02:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please send this in excel. Also i can not find the marketing date which you used in your expression.
Regards,
Kaushik Solanki
Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
419 Views
sagaraperera
Creator
2017-07-13
03:07 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
| SCCOD | Opening_Date | MARKETING_DATE | POLICY_NO | Data |
| SC019 | 10-Nov-2014 | 01 Jun 2015 | CO22153F0026512 | 522 |
| SC019 | 10-Nov-2014 | 01 Jun 2015 | CO22153W0002670 | 856 |
| SC019 | 10-Nov-2014 | 01 Jun 2015 | 0 | |
| SC019 | 10-Nov-2014 | 03 Jun 2015 | CO22151F0006835 | -11,504 |
| SC019 | 10-Nov-2014 | 04 Jun 2015 | CO22153C0001588 | 549 |
| SC019 | 10-Nov-2014 | 04 Jun 2015 | CO22153F0026601 | 522 |
| SC019 | 10-Nov-2014 | 04 Jun 2015 | CO22153F0026608 | 522 |
| SC019 | 10-Nov-2014 | 05 Jun 2015 | CO22153A0003952 | 549 |
| SC019 | 10-Nov-2014 | 08 Jun 2015 | CO22153F0026777 | 522 |
| SC019 | 10-Nov-2014 | 09 Jun 2015 | CO22151A0011272 | -6,000 |
| SC019 | 10-Nov-2014 | 09 Jun 2015 | CO22153A0003979 | 549 |
| SC019 | 10-Nov-2014 | 09 Jun 2015 | CO22151A0011620 | 60,649 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001953 | 1,658 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001954 | 2,758 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001955 | 2,538 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001952 | 3,858 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001956 | 2,758 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001943 | 1,658 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001944 | 1,548 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001946 | 3,858 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001949 | 3,638 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001960 | 2,483 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001961 | 2,538 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001947 | 2,648 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001948 | 2,208 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001945 | 3,308 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001950 | 2,208 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001959 | 2,208 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001957 | 4,078 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001958 | 2,208 |
| SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001951 | 3,088 |
| SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001964 | 1,768 |
| SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001962 | 1,988 |
| SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001963 | 2,648 |
| SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22151A0010376 | 6,285 |
| SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001968 | 1,988 |
| SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001967 | 3,418 |
| SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22153F0026992 | 522 |
| SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22153A0004000 | 549 |
| SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001965 | 2,428 |
| SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001966 | 2,098 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001974 | 2,868 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001984 | 1,658 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001981 | 2,208 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001975 | 1,548 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001977 | 2,098 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001985 | 1,438 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001971 | 1,548 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001986 | 2,208 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22151A0010250 | -54,326 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001972 | 2,758 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001978 | 2,648 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001982 | 2,208 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001980 | 4,408 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001976 | 2,538 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001983 | 2,318 |
| SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001979 | 2,538 |
| SC019 | 10-Nov-2014 | 16 Jun 2015 | CO22153F0027241 | 522 |
| SC019 | 10-Nov-2014 | 17 Jun 2015 | CO22153F0027277 | 522 |
| SC019 | 10-Nov-2014 | 18 Jun 2015 | CO22151A0011746 | 46,366 |
| SC019 | 10-Nov-2014 | 19 Jun 2015 | CO22153A0004049 | 549 |
| SC019 | 10-Nov-2014 | 19 Jun 2015 | CO22153A0004055 | 549 |
| SC019 | 10-Nov-2014 | 20 Jun 2015 | CO22154X0002010 | 1,658 |
| SC019 | 10-Nov-2014 | 20 Jun 2015 | CO22153C0001648 | 549 |
| SC019 | 10-Nov-2014 | 20 Jun 2015 | CO22154X0002014 | 4,188 |
| SC019 | 10-Nov-2014 | 20 Jun 2015 | CO22154X0002020 | 1,658 |
| SC019 | 10-Nov-2014 | 22 Jun 2015 | CO22153A0004073 | 549 |
| SC019 | 10-Nov-2014 | 22 Jun 2015 | CO22154X0002028 | 2,208 |
| SC019 | 10-Nov-2014 | 23 Jun 2015 | CO22153F0027613 | 522 |
| SC019 | 10-Nov-2014 | 23 Jun 2015 | CO22153F0027624 | 522 |
| SC019 | 10-Nov-2014 | 23 Jun 2015 | CO22153F0027566 | 522 |
| SC019 | 10-Nov-2014 | 24 Jun 2015 | CO22151A0010376 | -9,912 |
| SC019 | 10-Nov-2014 | 25 Jun 2015 | CO22151A0011870 | 54,326 |
| SC019 | 10-Nov-2014 | 25 Jun 2015 | CO22153W0002928 | 856 |
| SC019 | 10-Nov-2014 | 25 Jun 2015 | CO22151A0011878 | 125,441 |
| SC019 | 10-Nov-2014 | 25 Jun 2015 | CO22151A0011879 | 75,221 |
| SC019 | 10-Nov-2014 | 26 Jun 2015 | CO22153W0002963 | 856 |
| SC019 | 10-Nov-2014 | 26 Jun 2015 | CO22153F0027836 | 522 |
| SC019 | 10-Nov-2014 | 26 Jun 2015 | CO22151W0000462 | 9,125 |
| SC019 | 10-Nov-2014 | 26 Jun 2015 | CO22153F0027832 | 522 |
| SC019 | 10-Nov-2014 | 27 Jun 2015 | CO22154X0002058 | 3,528 |
| SC019 | 10-Nov-2014 | 29 Jun 2015 | CO22153A0004122 | 549 |
| SC019 | 10-Nov-2014 | 29 Jun 2015 | CO22153A0004123 | 549 |
| SC019 | 10-Nov-2014 | 29 Jun 2015 | CO22153F0027903 | 522 |
| SC019 | 10-Nov-2014 | 29 Jun 2015 | CO22153F0027901 | 522 |
| SC019 | 10-Nov-2014 | 29 Jun 2015 | CO22153A0004129 | 549 |
| SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22153F0028072 | 522 |
| SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22154X0002097 | 2,538 |
| SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22153F0028071 | 522 |
| SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22154X0002093 | 1,988 |
| SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22154X0002094 | 1,328 |
| SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22151A0011980 | 54,055 |
| SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22153F0028046 | 522 |
| SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22151A0011926 | 110,390 |
| SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22154X0002096 | 2,208 |
| SC019 | 10-Nov-2014 | 01 Jun 2016 | CO22154X0001974 | 4,486 |
| SC019 | 10-Nov-2014 | 01 Jun 2016 | CO22154X0001963 | 4,180 |
| SC019 | 10-Nov-2014 | 01 Jun 2016 | CO22154X0001971 | 2,650 |
| SC019 | 10-Nov-2014 | 01 Jun 2016 | CO22154X0001972 | 4,333 |
| SC019 | 10-Nov-2014 | 01 Jun 2016 | CO22154X0001979 | 4,027 |
| SC019 | 10-Nov-2014 | 01 Jun 2016 | 0 | |
| SC019 | 10-Nov-2014 | 02 Jun 2016 | CO22154X0001980 | 6,628 |
| SC019 | 10-Nov-2014 | 03 Jun 2016 | CO22154X0001953 | 2,803 |
| SC019 | 10-Nov-2014 | 03 Jun 2016 | CO22154X0001975 | 2,650 |
| SC019 | 10-Nov-2014 | 03 Jun 2016 | CO22154X0001943 | 2,803 |
| SC019 | 10-Nov-2014 | 03 Jun 2016 | CO22154X0001978 | 4,180 |
| SC019 | 10-Nov-2014 | 03 Jun 2016 | CO22163F0061141 | 596 |
| SC019 | 10-Nov-2014 | 04 Jun 2016 | CO22154X0001952 | 5,863 |
| SC019 | 10-Nov-2014 | 04 Jun 2016 | CO22154X0001967 | 5,251 |
| SC019 | 10-Nov-2014 | 04 Jun 2016 | CO22154X0001983 | 3,721 |
| SC019 | 10-Nov-2014 | 04 Jun 2016 | CO22154X0002020 | 2,803 |
| SC019 | 10-Nov-2014 | 05 Jun 2016 | CO22154X0001981 | 3,568 |
| SC019 | 10-Nov-2014 | 06 Jun 2016 | CO22163F0061369 | 596 |
| SC019 | 10-Nov-2014 | 06 Jun 2016 | CO22163F0061356 | 596 |
| SC019 | 10-Nov-2014 | 06 Jun 2016 | CO22163F0061424 | 596 |
| SC019 | 10-Nov-2014 | 06 Jun 2016 | CO22163F0061421 | 596 |
| SC019 | 10-Nov-2014 | 07 Jun 2016 | CO22163F0061588 | 596 |
| SC019 | 10-Nov-2014 | 08 Jun 2016 | CO22154X0001985 | 2,497 |
| SC019 | 10-Nov-2014 | 08 Jun 2016 | CO22154X0001982 | 3,568 |
| SC019 | 10-Nov-2014 | 09 Jun 2016 | CO22154X0001981 | -3,568 |
| SC019 | 10-Nov-2014 | 09 Jun 2016 | CO22154X0001961 | 4,027 |
| SC019 | 10-Nov-2014 | 10 Jun 2016 | CO22154X0002014 | 6,322 |
| SC019 | 10-Nov-2014 | 10 Jun 2016 | CO22154X0001948 | 3,568 |
| SC019 | 10-Nov-2014 | 12 Jun 2016 | CO22154X0002010 | 2,803 |
| SC019 | 10-Nov-2014 | 12 Jun 2016 | CO22161A0016003 | -68,380 |
| SC019 | 10-Nov-2014 | 14 Jun 2016 | CO22153F0026992 | 596 |
| SC019 | 10-Nov-2014 | 14 Jun 2016 | CO22163W0011601 | 990 |
| SC019 | 10-Nov-2014 | 14 Jun 2016 | CO22163W0011599 | 990 |
| SC019 | 10-Nov-2014 | 15 Jun 2016 | CO22163A0007979 | 1,499 |
| SC019 | 10-Nov-2014 | 15 Jun 2016 | CO22163W0011629 | 990 |
| SC019 | 10-Nov-2014 | 15 Jun 2016 | CO22163A0007982 | 1,499 |
| SC019 | 10-Nov-2014 | 15 Jun 2016 | CO22163F0062606 | 596 |
| SC019 | 10-Nov-2014 | 15 Jun 2016 | CO22163F0062602 | 596 |
| SC019 | 10-Nov-2014 | 16 Jun 2016 | CO22163F0062767 | 596 |
| SC019 | 10-Nov-2014 | 18 Jun 2016 | CO22151A0011746 | 47,166 |
| SC019 | 10-Nov-2014 | 20 Jun 2016 | CO22161A0017071 | -29,330 |
| SC019 | 10-Nov-2014 | 23 Jun 2016 | CO22163W0011888 | 990 |
| SC019 | 10-Nov-2014 | 24 Jun 2016 | CO22154X0002094 | 2,344 |
| SC019 | 10-Nov-2014 | 24 Jun 2016 | CO22163F0063756 | 596 |
| SC019 | 10-Nov-2014 | 24 Jun 2016 | CO22163F0063762 | 596 |
| SC019 | 10-Nov-2014 | 25 Jun 2016 | CO22151A0011878 | 97,468 |
| SC019 | 10-Nov-2014 | 25 Jun 2016 | CO22154X0002096 | 3,568 |
| SC019 | 10-Nov-2014 | 26 Jun 2016 | CO22154X0002097 | 4,027 |
| SC019 | 10-Nov-2014 | 29 Jun 2016 | CO22153F0027901 | 596 |
| SC019 | 10-Nov-2014 | 29 Jun 2016 | CO22161A0018060 | 116,219 |
| SC019 | 10-Nov-2014 | 30 Jun 2016 | CO22161A0016562 | -49,880 |
| SC019 | 10-Nov-2014 | 01 Jun 2017 | CO22153C0001532 | 1,499 |
| SC019 | 10-Nov-2014 | 01 Jun 2017 | CO22171A0022190 | -49,555 |
| SC019 | 10-Nov-2014 | 01 Jun 2017 | CO22171A0021205 | -14,207 |
| SC019 | 10-Nov-2014 | 01 Jun 2017 | 0 | |
| SC019 | 10-Nov-2014 | 02 Jun 2017 | CO22173F0111333 | 630 |
| SC019 | 10-Nov-2014 | 02 Jun 2017 | CO22173W0021273 | 1,075 |
| SC019 | 10-Nov-2014 | 05 Jun 2017 | CO22171A0022431 | -23,280 |
| SC019 | 10-Nov-2014 | 05 Jun 2017 | CO22173F0111494 | 630 |
| SC019 | 10-Nov-2014 | 05 Jun 2017 | CO22173F0111600 | 630 |
| SC019 | 10-Nov-2014 | 05 Jun 2017 | CO22173F0111515 | 630 |
| SC019 | 10-Nov-2014 | 05 Jun 2017 | CO22173A0010663 | 1,924 |
| SC019 | 10-Nov-2014 | 07 Jun 2017 | CO22173F0111819 | 630 |
| SC019 | 10-Nov-2014 | 07 Jun 2017 | CO22173F0111936 | 630 |
| SC019 | 10-Nov-2014 | 07 Jun 2017 | CO22173F0111802 | 630 |
| SC019 | 10-Nov-2014 | 12 Jun 2017 | CO22173W0021476 | 1,075 |
| SC019 | 10-Nov-2014 | 13 Jun 2017 | CO22173A0010712 | 1,924 |
| SC019 | 10-Nov-2014 | 14 Jun 2017 | CO22173F0112750 | 630 |
| SC019 | 10-Nov-2014 | 14 Jun 2017 | CO22173W0021548 | 1,075 |
| SC019 | 10-Nov-2014 | 14 Jun 2017 | CO22173F0112751 | 630 |
| SC019 | 10-Nov-2014 | 14 Jun 2017 | CO22173F0112752 | 630 |
| SC019 | 10-Nov-2014 | 15 Jun 2017 | CO22173F0112796 | 630 |
| SC019 | 10-Nov-2014 | 16 Jun 2017 | CO22173F0112866 | 630 |
| SC019 | 10-Nov-2014 | 16 Jun 2017 | CO22173F0112863 | 630 |
| SC019 | 10-Nov-2014 | 16 Jun 2017 | CO22173F0112859 | 630 |
| SC019 | 10-Nov-2014 | 19 Jun 2017 | CO22151A0011746 | 45,100 |
| SC019 | 10-Nov-2014 | 19 Jun 2017 | CO22173F0113094 | 630 |
| SC019 | 10-Nov-2014 | 20 Jun 2017 | CO22171C0007308 | 23,080 |
| SC019 | 10-Nov-2014 | 20 Jun 2017 | CO22173F0113280 | 630 |
| SC019 | 10-Nov-2014 | 21 Jun 2017 | CO22173F0113574 | 630 |
| SC019 | 10-Nov-2014 | 21 Jun 2017 | CO22173F0113598 | 630 |
| SC019 | 10-Nov-2014 | 22 Jun 2017 | CO22173F0113706 | 630 |
| SC019 | 10-Nov-2014 | 23 Jun 2017 | CO22171A0023604 | 40,430 |
| SC019 | 10-Nov-2014 | 25 Jun 2017 | CO22151A0011878 | 91,775 |
| SC019 | 10-Nov-2014 | 27 Jun 2017 | CO22173F0114169 | 630 |
| SC019 | 10-Nov-2014 | 28 Jun 2017 | CO22161A0018060 | 80,321 |
| SC019 | 10-Nov-2014 | 28 Jun 2017 | CO22173F0114274 | 630 |
| SC019 | 10-Nov-2014 | 28 Jun 2017 | CO22171A0023693 | 68,815 |
| SC019 | 10-Nov-2014 | 29 Jun 2017 | CO22173C0004022 | 1,499 |
419 Views
arvind_patil
Partner - Specialist III
2017-07-13
03:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sagara,
On what basis you require 6 against Year 17. as per calculation, it shows 32.
Formula is:=(max(MARKETING_DATE) - (Opening_Date))/30
| M3 | M3 | M3 | ||||
| SCCOD | SCNAME | Opening_Date | YEAR | sales | No_Of_Month | Avg_Sales |
| 01 | P | 10-Nov-2014 | 2014 | 26,669 | 2 | 16,328 |
| 10-Nov-2014 | 2015 | 187,080 | 12 | 15,590 | ||
| 10-Nov-2014 | 2016 | 230,062 | 12 | 19,172 | ||
| 10-Nov-2014 | 2017 | 189,387 | 6 | 31,565 | ||
| 10-Nov-2014 | Total | 633,199 | 32 | 20,017 |
Thanks,
Arvind Patil
419 Views
