cancel
Showing results for 
Search instead for 
Did you mean: 

Using "Where" operator sometimes generates a Null Value

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Helen,

Just wanted to know if the query that is the value of the Fiscal Dimension dependent upon some other condition.

Have you tried breaking the formula to smaller chunks?

Have you tried using other Conditional Operator as "Nested IF".

Regards,

Ekta Srivastava

Former Member
0 Kudos

Hello, Ekta!

in response to your help:

Q: Is the query that is the value of the Fiscal Dimension dependent upon some other condition?

A: No, the dimension "[Fiscal Quarter]" is not dependent on anything else.

Q: Have you tried breaking the formula to smaller chunks?

Have you tried using other Conditional Operator as "Nested IF".

A: No, I haven't tried that. Any suggestions? It sounds reasonable.

Thanks,

Helen

Answers (0)