Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);