average but not avg()

[#1]

Hi

I know avg is not that function I need, but I am not sure what is...

I have put all the details in my example file.

Thanks

Oli

[swuehl · Accepted solution]

Try

=sum([# Order line value]) / count( distinct [Inv Month])

[kji]

sum([# Order line value])/Count (DISTINCT [Inv Month])

[#4]

Hi

use this expression

sum([# Order line value])/Count(TOTAL DISTINCT [Inv Month])

find the attached Qvw

its worked fine.

[adamwilson]

this gives the desired result, although I would try to remodel the data to avoid using DISTINCT

sum([# Order line value]) / Count(DISTINCT [Inv Month])

[#6]

hi i don't understand what u want clearly,do u want something like this?please check attached file

[#7]

Like attached?

Or put this in your expression field:

=avg(aggr(sum([# Order line value]),[Inv Month]))

[#8]

I am attaching your application with two options, one based on counting the number of months and the other using Dimensionallity().

[MayilVahanan]

Hi

Try like this

=If(RowNo() = 0 or IsNull(RowNo()),  Sum([# Order line value]) / Count( DISTINCT

[Inv Month]),  Sum([# Order line value]) / Count( [Inv Month]))

[marcus_malinow]

Hi Oli,

this expression should give you a cumulative sum of your [# Order Line Value] field. It should be simple to then calculate your average.

rangesum(above(total sum([# Order line value]), 0, only([Inv Month])))

Marcus

--edited as I missed out the rangesum!