on 09-12-2008 11:42 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.