Hi all,

I have a cube with a certain Measure called "Bruto Price 30s" (i think the
name explains the content). when users select (in the pivot table) months on
the rows, and channels on the columns, they want to see the average bruto
price. Therefore, i created a calculated member with this formula :

sum({[Bruto Price 30s]}) / count({[Bruto Price 30s]},ExcludeEmpty)

Unfortunately, this gives the same result as the sum of [Bruto Price 30s].
Has anyone got an idea why its still using its sum ?

Thanks!

PS: the avg([Measures].[Bruto Price 30s]) function didn't work either

You might want to specify the set that you want to avg against. Something
like:
Avg({[Month]}, [Your measure]).

"Koen" wrote:

You could also try creating a real count measure in your cube, that way
you would not have to dynamically count descendants at runtime.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <FEB69D24-9F58-494F-9B54-575491E10FE9 (AT) microsoft (DOT) com>,
yongli (AT) discussions (DOT) microsoft.com says...

Darren, i used your solution. I created the member and set it to invisible.
THanks to everyone for their assistence!

Greetz, K

"Darren Gosbell" wrote: