Using COALESCE, and TRIGGER the result still in NAN

[Kal_Lam]

@decysophan, seems like you are using the coalesce function in a wrong way. This post discussed previously should provide you a working example of how it’s used:

If statement to score 'select many' responses

Maybe the image outlined below should solve your issue: 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: condition for Q1 met [Image 3] Data entry screen as seen in Enketo: condition for Q1 & Q2 met [Image 4] Data entry screen as seen in Enketo: condition for Q2 met [Image 5] Data entry screen as seen in Enketo: condition for neither Q1 nor Q2 met [Image 6] Reference xlsform: Calculation.xlsx (11.6 KB) …

You should also be able to find more discussions on coalesce function here.