Combine ranges of separate variables

0     1     Edited Nov 3, 2016 by 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)?


Comments

0

Rob Smith 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)

Leave a Comment

Please sign in to leave a comment.