Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to find out the average calls per day but only for work days. In my data, the sum(#of Calls) is 0 on non working days so maybe I could calculate the data by excluding those days where the sum(#ofCalls)=0, so maybe a count of that. I was thinking this would be some sourt of sum(#ofcalls)/Count(pick(match())) but I am not completely sure. I now think this might need set analysis.
Any help is greatly appreciated!
Maybe
Avg(if(weekday(DateField)<5,[#of Calls]))