Steve,

I tried getting the Substring() and Left() to work, but wasn't able to. In my research, I found the Subset() and was able to get that to work with...

The members of CalendarYear are 2010, 2009, 2008, etc.

The parameter for ReportDate is '2009-12-01T00:00:00' - this is how I've gotten it to work with our cube.

Thank you!

Steve,

I was able to modify the query to look like this:

WITH

MEMBER

[Measures].[Promises Taken Per Hour2] as

IIF (IsEmpty([Measures].[Production Hours]),0,[Measures].[Promises Taken]/[Measures].[Production Hours])

MEMBER [Measures].[Promise Taken Rate] AS

IIF(IsEmpty([Measures].[Right Party Contacts])...

Thank you very much, Steve! That did work for me!

Now I am trying to modify a separate YTD MDX query, but am having trouble being able to only return...