Qlikview "AVERAGEIF" function?

[Anonymous]

Hi all,

I'm trying to average in the right most column the CSA prices of SKUs on the left.  So, for example, one SKU may have three CSA prices, how do I average these three prices without removing the individual prices as a dimension?

I've tried these two formulas and neither have worked:

Avg(aggr(Avg ([Final Price]), PK_SKU))

   avg({1} Final Price   )

Any help would be greatly appreciated

Thanks

[vishsaggi]

May be this?

= Sum(aggr(Avg ([Final Price]), PK_SKU))

[sunny_talwar]

How about this

Avg(TOTAL [Final Price])

or

Avg(TOTAL Aggr(Avg([Final Price]), PK_SKU))

[Kushal_Chawda]

=avg(total <PK_SKU> aggr(Avg([Final Price]), PK_SKU))