Hi all,
I am having trouble with picking out only blank values in my CUBE formula. Hope someone can help?
=CUBEVALUE("ThisWorkbookDataModel","[Measure].[Assessment a.exceeds 45 days]","[Assessment].[Step End Date].["&""&"],"[Service Area].["&A16&"]")
Section in bold is where i wish to enter a blank parameter. Anyone able to help?
Using the [All] expression works so everything else with the formula is fine...
I am having trouble with picking out only blank values in my CUBE formula. Hope someone can help?
=CUBEVALUE("ThisWorkbookDataModel","[Measure].[Assessment a.exceeds 45 days]","[Assessment].[Step End Date].["&""&"],"[Service Area].["&A16&"]")
Section in bold is where i wish to enter a blank parameter. Anyone able to help?
Using the [All] expression works so everything else with the formula is fine...