Filtered average

I have a measure [Completed Step Count] in cube CompletedStep whose
value is 0 to N.

Ali...

I need to calculate the average of that measure for all NON ZERO
values.

I've been trying this concept:

sum(completed step count) / count( records have completed step fact >
0)

but can't get the syntax right

Sum([Measures].[Completed Step Count])/count(Filter{
[Product].[BySAPPart].Members }, [Measures].[Completed Step Count] >
0))

I've also experimented with "WITH" and "AVG" with no success.

Any ideas?

Splodge...

So he's not talking about coffee then:)))

Tickettyboo...

yep! Take your socks off and use your toes as well as your fingers to
count on. :-)

noreen...

Oh that's clever Boo I could never do goesinters!!only addups ;-)))))

Rabbit...

The answer is 42 :-)

biffo...

Why not try the other then ;-))))

Flyiñg Ñuñ 2°°6 +...

Isn't it difficult getting a bit of the other these days Ollie? ;)

biffo...

Have you have found a solution then Stanley ?? ;-)))

Flyiñg Ñuñ 2°°6 +...

Everything is _dissolving_ in this heat Ollie. ;)

biffo...

More like dissolved here Stan ;-)))

Flyiñg Ñuñ 2°°6 +...

Exactly - says he sitting in a pool of perspiration. :)

Ali...

Yes, I have an idea you posted to the wrong group.

If you had given an indication of which Application or programming language
you are using, someone *may* have been able to help.

Clive...

My brain started hurting after reading the first line!

Flyiñg Ñuñ 2°°6 +...

You did well Clive - getting right to the end of the line - that is. LOL