Exie Posted January 14, 2009 Share Posted January 14, 2009 Hi,I have a report I'm making which passes a parameter into an MDX query. It's a sales report, and when I use one sales rep, it works cool, but when I use a new sales rep who doesnt have any sales for last month, I get:Error filling print... No such tuple ([Measures].[Prior MTD Sales] on axis 0.The measure is defined as: member [Measures].[Prior MTD Sales] as='Sum(Mtd(ParallelPeriod([Time].[Year], 1.0, $P!{FullDateSelection} )), [Measures].[Total Value])', format_string = "|$#,###.00|"I know there will be no data for the particular rep, can I just get it to return blank or null or something rather than erroring out ? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now