Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Guys,
When I sum worked hours of an employee for a particular month and year, I'm not getting the expected result.
Code I have used,
Hours0:
LOAD EmployeeID,
ProjectID,
ReleiveStatus,
sheet_date as Sheetdate,
worked_hours as WorkHours
Resident ResourceTimesheet;
Fact:
load Date(floor(Sheetdate),'MM/DD/YYYY') as Timesheet,
Year(Sheetdate) & '|' & Month(Sheetdate)& '|' & Date(Sheetdate) as Sheetdate,
EmployeeID,
ReleiveStatus,
If(len(WorkHours)>0,WorkHours,0) AS WorkHour
Resident Hours0;
Plz suggest a way to achieve this.
Thanks in advance.
I have attached the sample of data along with this
Seems like the same query as this one?
The xls file is corrupted. Please re-upload it.
What is your expected result ?
I have replaced the file
I have replaced the file