Average Cumulative With 1 Value

[pgalvezt]

Hello,

I´m Looking for a formula that can calculate the avg total in QlikView.

I have a count of names and months I need to show the cumulative average by month.

I put an excel file with what I want.

My Dimensio is Month

My Expression is Count(Names)

I need the cumulative average by month

Thanks...

[jerem1234 · Accepted solution]

you can try:

rangeavg(above(count(Names), 0, rowno()))

Hope this helps!

[MK_QSL]

Check enclosed file...

[pgalvezt]

Hi Jerem,

How can I obtain the total (Annual)?

Thanks

[MK_QSL]

IF(Dimensionality()=0,Sum(Sales)/Count(Distinct Month), RangeAvg(Above(SUM(Sales),0,RowNo())))

[jerem1234]

What do you mean by total (Annual)?

Do you mean the avg of all the months? You can get that with avg(total aggr(count(Names), Month)).

If you want it to appear in the total section of your column you are accumulating, you'll need to separate it out using dimensionality() like:

if(dimensionality()=0, avg(total aggr(count(Names), Month)), rangeavg(above(count(Names), 0, rowno())))

Hope this helps!