Using COALESCE, and TRIGGER the result still in NAN

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,



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

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.

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


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


Dear Kal

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

and this is the result

@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:

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