VAR for column categorisation and later use in measures

[GTRC]

Hi, 

I am trying to create 2 categories for multiple columns using VAR. In the image below OVERALL, QLTEACH, and STDSTRUC are one category '_question_4' (questions with 4 points answers) and the STDRELEV, TCHACTIVE are another _question_5' (questions with 5 points answers). 

I want later to be able to use SWITCH and AVERAGE based on the category they are in. This is a small sample of the dataset, so I need an efficient way to group the columns so I can later use the same measures based on criteria or names.

First time on the forum, hope someone will be able to help me! 

Thank you

[FreemanZ]

hi @GTRC ,

not sure about your expectation. could you tell us more about it?

[GTRC]

Hi @FreemanZ,

Those are survey answers and I am trying first to calculate valid answers. For example, out of 11 questions, it should be 8 questions answered correctly. Then, I need to change the scoring answers to another number to create a rate. For example, if the questions have 4-point answers, they should be 1=0, 2=33.33, etc. If the questions have 5-point answers, they should be 1=0, 2=25, etc. 

So, I thought if I categorised the question into a "group" then it would be easier to use it in measure. Thus my use of VAR.