I have a question composite issue. My client has a question composite that asks patients to rate their stay at a particular hospital. Well this response column should only return ratings which would be one through one hundred. The issue is that this column also takes into account the yes or no responses as well and this screws up the average response. Is there a way within the RPD to illiminate this column from taking the yes or no responses into account?
I would suggest to evaluate these Yes and No values in the form of Number format so that you can add them in 1 to 100 rating.
See that how you can fit in your data, I treat Yes=1 and No=0 to sum up to the rating.