Help

Sat, 26 Jul 2014 15:54:32 GMT

Hi Everyone,

Need Your help!!

I want all the emp who have claimed for the current month and those who have submitted the same bill on the previous month.

Attached the sample data.

Thanks and Regards,

Priya

Re: Help

maxgro — Sat, 26 Jul 2014 16:24:38 GMT

result

expression

if(count({$ <ClaimYearMonth={"$(=date(max(ClaimDate),'YYYYMM'))"}>} ClaimAmount)>=1

and

count({$ <ClaimYearMonth={"$(=date(AddMonths(max(ClaimDate),-1),'YYYYMM'))"}>} ClaimAmount)>=1

,1,0)

script

LOAD

EmpID, BillNo, ClaimDate, ClaimAmount, date(ClaimDate, 'YYYYMM') as ClaimYearMonth

FROM DATA.xlsx (ooxml, embedded labels, table is Sheet1);