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.
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?