Calculate using IF Formula with Multiple Expression (composite index/weighted score)

User Support Form Building
, , ,
10

Well if this is your requirement, you could design your survey project using the following if-statement as outlined in the image shared below:

In the survey tab of your xlsform:

Image 1
Image 11211×187 6.42 KB

In the choices tab of your xlsform:

Image 2

Data entry screen as seen in Enketo: If option 1 is selected, the system gives a score of 3

Output 1

Data entry screen as seen in Enketo: If option 3 or option 2 is selected with 1, the system gives a score of 3

Output 2.1

Data entry screen as seen in Enketo: If option 3 or option 2 is selected with 1, the system gives a score of 3

Output 2.2

Data entry screen as seen in Enketo: If option 3 and option 2 is selected, the system gives a score of 2

Output 3

Data entry screen as seen in Enketo: If option 3 is selected, the system gives a score of 2

Output 4

Data entry screen as seen in Enketo: If option 2 is selected, the system gives a score of 1

Output 5

Reference xlsform:

Composite Index.xlsx (13.1 KB)