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