Forum Discussion
Connecting multiple data points
Hello, I am trying to analyze a survey answers which has 800+ rows based on multiple data points, from within the some questions answers. the survey has 119 questions, each question with 5 option...
matout , a new column like
new column =
Var _1 = if([Bank Account]= "Yes" ,1,0) + if(not(isblank([Accounting Practice])),1,0)+ if([Accountant]= "Yes" ,1,0) + if([External Auditor]= "Yes" ,1,0) + if([Online Banking]= "Yes" ,1,0)
return
Switch( True() ,
_1 = 5, "Organized",
_1 >0 , "Semi Organized",
"Not organized"
)
Change as per need
Hello, thank you for the answer.
this solution is helpful, however, there are 3 different values in the "Accounting practice" column.
How can I diffrentiate them, this is not just true or false.