Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i am trying to get total work hours on weekend .. and i am getting wrong result. in excel i manually check this return me result 128 where currenlty dashboard shows me wrong result which is 815..
i am trying this expression
If(WeekDay(Attendance.AttendanceDay) = 'Sat' or WeekDay(Attendance.AttendanceDay) = 'Sun',Attendance.AttendanceDay,SUM(Attendance.WorkingHours))
kindly check dashboard and excel file
Try this:
SUM(If(WeekDay(AttendanceDay) = 'Sat' or WeekDay(AttendanceDay) = 'Sun',WorkingHours))
Try this:
SUM(If(WeekDay(AttendanceDay) = 'Sat' or WeekDay(AttendanceDay) = 'Sun',WorkingHours))
Hi!
Please, dont duplicate posts. As I said in the other one, try
Sum({<AttendanceDay = {"=WeekDay(AttendanceDay)>=5"}>}WorkingHours)
Jaime.
hi
this expression should work for you
sum(If(WeekDay(AttendanceDay) = 'Sat' or WeekDay(AttendanceDay) = 'Sun',WorkingHours))
but your answer did not show me correct results..