exclude the value 0 (zero) in the average of rows

[#1]

month	2012	2011	2010
1	20331	21596	16832
2	20802	22255	17797
3	19272	23013	18037
4	19993	21338	17799
5	20719	23831	19521
6	26881	24096	21399
7	21272	20979	19885
8	10639	21726	18141
9	0	21272	17512
10	0	19739	18198
11	0	20928	19741
12	0	19650	20104
avg	13326	21702	18747

Hello,

Does anybody know how to exclude the value 0 (zero) in the average of rows? In the case above it's including the zero's but that is not what i want because those months haven't past yet.

Thanks!

[Anonymous]

i would suggest.. you keep the coming months values to be as Nulls.

That should fix your average expression.

[#3]

Hi,

please see the attached example.

Maybe it´s helpful to get the right idea.

Good luck!

Rainer

[daveamz]

Hi,

Or, if you prefer set analysis:

avg({<[2012]=[2012]-{0}>}[2012])

Regards,

David