Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Using "Where" operator sometimes generates a Null Value

Hello,

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,

Helen Gonzalez

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question