hi,
i am trying to count policy for that i did count(employee id). it showing all the policies including expired also.
what i need is i need to compare the date like
expired date>=system date. then it will show only active policy.
for that i did in backend
test:
LOAD
EMPLOYEE_POL_ID as EMPLOYEE_POL_ID_resid,
PLAN_ID as PLAN_ID_resid,
EMPLOYEE_ID,
MEMBER_EXIT_DATE as MEMBER_EXIT_DATE_resid,
if(date(MEMBER_EXIT_DATE)>=date(Today()),count(EMPLOYEE_ID)) as new_id
Resident EMPLOYEE Group by EMPLOYEE_POL_ID,PLAN_ID,EMPLOYEE_ID;
while loading it shows error in expression.
can anyone tell me what i am doing wrong
Thanks
