WHERE operator and UserResponse function 1

[elac]

I try to define a new variable with the following formula :

=MyMeasure Where MyDimension=UserResponse("MyDataProvider","MyPrompt&quot

I always get a syntax error focused on 'UserResponse'.

If I define another variable with formula =UserResponse("MyDataProvider","MyPrompt&quot, it works.


Does anybody have a working sample code with that kind of formula ?

Thanks.

 

[promero]

&quot;where&quot; clause syntax is a lot restrictive. Is must be of the form &quot;where (<variable>=value)&quot;, where &quot;value&quot; must be a non-negative numeric constant, a text constant (&quot;text&quot or a date constant ('date').

When I need &quot;value&quot; to be something more complicated, i do the following: I replace &quot;where (<variable>=value)&quot; with &quot;where (<variable=value>=1)&quot;, where <variable=value> is a new variable with the formula &quot;=<variable>=value&quot;.

This solution can be used to make multiple conditions in one where clause: &quot;where (<condition>=1)&quot;, where <condition> is a variable with the condition formula, that can include multiple variables.