Dear All,
Kindly note that I am currently using the below appended “Selection Tool” to arrive at the sales value for the past 3 months.
YEAR= 2017/2018
MONTH= JAN/DEC/NOV
(PLEASE REFER ATTACHMENT)
The issue I am encountering is when I apply the said selection tool, the value includes the Jan 2017 figure as well
Hence please advise me as to how I could avoid in arriving at the unwanted figure (Jan 2017)
MY SCRIPT
LOAD BCOD,
CLA_CODE,
PRD_CODE,
POLICY_NO,
REF_NO,
DATE(floor(MARKETING_DATE)) as MARKETING_DATE,
MDATE,
YEAR,
MONTH,
NAME,
ME_CODE,
DATE(floor(TRN_DATE)) as TRN_DATE,
POL_PERIOD_FROM,
SCCOD,
CP,
RS,
TC,
GROSSTOT as sales ,
TYPE,
N_R_NOS1,
F_NOS2
