average

[bvann040684]

This is probably simple but I'm still new to QV so...

I set up a count(x) expression to give me the total/ month, but now I need to get the average/day but that requires either the number of work days in a month or selected days in the Application. Can someone point me in the correct direction.

BV

[#2 · Accepted solution]

Count(x)/count(distinct(date(date))) would do it.

(I've masked the date to date explicitly in case you have a datetime. Masking to date should turn it into a date, with no hours/mins, etc.)

[bvann040684]

Thank you I really appreciate you help, it works perfectly.

I actually have one more issue with that same table if you don't mind. I have built this in a pivot table and instead of allowing me to sum the actual numbers in the column it sums the expression (I'm assuming) What can I do to get it to sum the column?