Using COALESCE, and TRIGGER the result still in NAN

[decysophan]

Dear all

need your help , that i got problem in my result, of the Kobo calculation, the result still in NAN, is someone can take a look of my xls Form, especially the result from SURVEY sheet Line number 63 and 64,

thank you in advance,

Sincerely

decy

[decysophan]

I’m new User, can’t attach the XLS survey form

[Kal_Lam]

Welcome to the community, @decysophan! You should now be able to share your XLSForm in the community forum, but please be sure that you only share the relevant part of your issue so that the community should be able to help you out.

[decysophan]

HI kal

Thank you, but unformtunatelly still cant Attach the Files, but here is the Link in my Gdrive about the files and the issue

Here Is The Files

Thank you

dc.-

[Kal_Lam]

@decysophan, kindly please share your XLSForm instead of sharing the google sheet link. Please also share with us the exact part of your issue (not the entire XLSForm). This should help us save the testing time of the community.

[decysophan]

Dear Kal

here is the Files
FORMULA SRPI Ed4.xlsx (19.5 KB)

and this is the result

[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.