logic:
iif(measure.name = "headcount",Avg(Date.CurrentMember.Children
),Sum(Date.CurrentMember.Children ))

I need to get the name of the measure. If it is the same as stated in the
logical expr then week date should average, else sum.

HELP!

Measure.CurrentMember.Name

Am still getting an error when I do this:
IIF(Measure.CurrentMember.Name =
"no_of_workers",Avg(Date.CurrentMember.Children),S um(Date.CurrentMember.Children))

The error I get is: Formula error - syntax error - token is not valid:
"IIF(^Measure^.CurrentMember.Name =
"no_of_workers",Avg(Date.CurrentMember.Children),S um(Date.CurrentMember.Children))"

HELP!

"OLAPMonkey (http://olapmonkey.blogspot.c" wrote:

what is wrong with my mdx?
iif(isempty(Measures.Members("Number Of CSAs"),
Avg(Date.CurrentMember.Children) , Sum(Date.CurrentMember.Children))

"misheL" wrote:

Try:

is [Measures].[no_of_workers],
Avg(Date.CurrentMember.Children),
Sum(Date.CurrentMember.Children))

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

thanks much!


"Deepak Puri" wrote: