Average formula

[qlikviewaf]

Hi,

i have the following data set, lot of order line with different date.

I would like to have the average of column 3, regardless the fact that there are several line.

Basically i would like to select January and February and get as AVERAGE , 3 (2+4/ 2 MONTH).

Which is the right formula to get this result?
Thank you!

[Anil_Babu_Samineni]

Perhaps this?

Sum(Distinct Measure)/Count(MonthField)

[qlikviewaf]

no is not giving the right results

[Anil_Babu_Samineni]

Please provide sample input and may be expected result also helpful. And which object you want to test?

[qlikviewaf]

Find attached

with the selection January and February i should get 1,5 as allocated Instrument average.

[Anil_Babu_Samineni]

It showing section access, Will u remove that and reload() then share. Or provide credentials

[qlikviewaf]

i removed section access

[Anil_Babu_Samineni]

Seems, You forget to reload. TRy to reload and share

[qlikviewaf]

basically i would like to have the AVERAGE of the MONTH AVERAGE

app reloaded

for jan and february the results should be 2

[Anil_Babu_Samineni]

Sorry - I can't help until unless you shared with out access. may be share sample inline table and result set?