Sum of Integer Inputs (when the inputs depends on previous question, as multiple selection)

[aditya]

Dear team, i am trying to sum integer inputs. It is working fine when all the fields are having data, But as relevance of the input fields (row 76 to 81) are depends on multiple selection from question in row 73, hence it will be the case that all values are not get entered for row 76 to 81. In such case the calculation field is not working. Please help, as this might required some additional function, which i do not know. Below is the image for your reference.

Best regards

[Kal_Lam]

@aditya, you could use the coalesce (as outlined in the post shared previously) and that should solve your issue:

Question Selection and point Calculation (weighted score/simple composite index)

Hi @PALASH9698, You could do this in a simple way as outlined in the image below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enketo: [Image 3] Reference xlsform: Weighted Score Sample.xlsx (11.9 KB) Have a great day!

This post too should be helpful:

“NaN” appearing in calculated value. How do we get rid of this?

Hi @hussaisa, Would you mind checking the xlsform. It should now work. Kindly please be informed that you could use the coalesce() function to stop seeing the NaN as you are currently seeing. Reference xlsform: Conditional_Clacluations.xlsx (11.6 KB) Have a great day!

[aditya]

@Kal_Lam

Thankyou very much