Need to convert expresssion from Excel to Qlikview

[#1]

Hello,

I wrote a simple expression in Excel where you can select a month or range of months, sum the values in that range, and divide by the number of months in the range.

The data is loaded into Qlikview as CrossTable(Month, Worked, 7) . The field that needs to be summed is Worked

How can I write this expression in Qlikview so that it changes as I select different months/ranges?

[johnw]

Perhaps one of these?

sum(Worked)/count(distinct Month)

avg(aggr(sum(Worked),Month))

[#3]

Thanks John!

Actually, I was able to get it working using this:

=num(sum(Worked)/GetSelectedCount(FiscalMonth),0)