NVL function on tuples

[wyconian]

Hi

I'm hvaing problems adding functions to tuple statements can you help?

What I'm tyring to do is say something like tuple([WTD], NVL([NET SALES],0)) but when I try to add any functions to the tuple statement the query goes completely to pot and can't find any of the items in the query.

Any ideas?

Thanks for the help again.

[rockytopmark]

Mixing relational functions with Dimensional will generally not workout as you intend.

Are you trying to force a ZERO where there is a NULL returned?  If so, there is no way to do that in a dimensional world, unless there is truly a tuple of those specific members. 

You might try using the member() function in some form here, to create the Tuple you need.  It would be nice to know if there really is a way.

[wyconian]

That's exactly what I was trying to do and you're right it doesn't work.  Oh hum...

Thanks for the response.