Hello ODKers ,
In an XLSForm I want to add a null value and number . I have a sheet where first i want to ask about which type of employees are present i.e whether full time or part time employees in select multiple type question . If he selects full time then I will ask how many full time employees are there if he selects part time I will ask how many part time are there . In the next question i want total employees present , which is nothing but sum of full time and part time . I want to show a hint where i will add part time and full time and show him how many he has to fill in the total employees field. If both part time and full time are filled then that sum works if any one is not filled then the sum is "Nan" and there is no hint shown . I figured out the reason being the empty field when added with non empty field the sum is "Nan" . So i wanted to know whether i can change that empty field to 0 .
I tried by adding if condition the constraint section where it works great , but in an big organisation that will be a very tedious task . So I want to convert empty field to zero.
Thanks and Regards,