Anonymous
Is there a way to have Report Builder combine ranges of separate variables (for example, % of sample that selected 1-3 out of 10 for variable X or variable Y)?
robsmith
Nov 3, 2016
Yes. You would use the form:
pctin(expression,true) – This gives you the percent of respondents where expression equals true.
For expression, we’ll use the criteria you explained:
(x >= 1 and x <= 3) or (y >= 1 and y <= 3)
So that gives the following RB syntax:
pctin((x >= 1 and x <= 3) or (y >= 1 and y <= 3), true)
Comments