Help

[#1]

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

[maxgro]

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

t:

LOAD

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

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