Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
please check attached qvw. i want to get average hours and colur it in red when average is less than 8.
is it possible.
Are you trying to get this?
Please find attached.
No, this is not what i want.
i want to get the average of all the dates
sum(sum(hours)) - for all 10 days / count(number of days) 10
hi,
try with total
like Sum(Total hours)/ count(distinct number of days)
Regards
Try this pls.
Let me know.
if you don't get required result.
no, you get daily average for all members, but i want the average hours of each member for whole period
can you please share a sample
Are you trying to get this?