Sum Function

[Anonymous]

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

[sunny_talwar]

Seems like the same query as this one?

sum of hours

[micheledenardi]

The xls file is corrupted. Please re-upload it.

What is your expected result ?

[Anonymous]

I have replaced the file

[Anonymous]

I have replaced the file