Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

howto write avgerage function with MDX 1

Status
Not open for further replies.

matjazperpar

Programmer
Sep 25, 2001
1
SI
Untill now i was using style like:
[Measures].[Store Sales]/[Measures].[Sales Count]

I would like to write this with MDX with AVG() function.
I need average over all dimensions not just one.

please help me,
matt
 
the syntax is :
Avg(set[, numeric expression])

see if this works

Avg({Customers].[country].members}, [sales count])

using your code:
Avg({[Measures].[Store Sales]},[Sales Count]

hope it works

Sam
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top