Using "Where" operator sometimes generates a Null Value
I am struggling with the following problem:
Sometimes when I use the "Where" operator, I get a Null value that I can't get rid of. For example:
[Fiscal Quarter] Where [Fiscal Quarter] = "2009 Q3"
Returns: "2009 Q3" and [Null]
Note: The object [Fiscal Quarter] is a dimension.
Conversely, when I use this formula:
[Revenue] Where [Fiscal Quarter] = "2009 Q3"
There is just one result, e.g., $100,000, as expected.
Is there something I can add to the first formula so that I do not get the Null response?
thanks so much,