I want to remove NaN from the Form

[testwbd]

Hi,
Its shows NaN, But when I put the date it working. I want to remove NaN from the Form. Please help.
Hasib

[Kal_Lam]

Welcome to the community, @testwbd! You could use the coalesce function as outlined in this post discussed previously:

Calculating the sum

You could do the same as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: [Image 2] Reference xlsform: Sum.xlsx (8.9 KB)

Feel free to go through these posts discussed previously, which discuss the coalesce function.

[testwbd]

Thank You Kal_Lam for the solution.
I am wondering date calculation Start date to End Date.
See the formula calculation I have use int(decimal-date-time(${EndMission}) - decimal-date-time(${StartMission})) + 1
As next Note Question: Duration of your mission NaN Day(s)
if the NaN replace by “0” then it looks good!

[Kal_Lam]

@testwbd, maybe you will need to share the relevant part of the XLSForm so that the community should be able to help you out.

[testwbd]

Dear concern,

I have attached my XLSForm. Please see

Mission to [BGD CMU].xlsx (17.2 KB)

[Kal_Lam]

@testwbd, you could use this workaround (to skip the note question unless there is an entry in the date) as shown in the image below:

Reference XLSForm:

Mission to [BGD CMU].xlsx (17.0 KB)

[testwbd]

Thank you!
Now it’s working. But need to put [“”] : ${StartMission}!=“” and ${EndMission}!=“” double not single.
Thanks again for your quick support.

[testwbd]

Thank you! Now it’s working. But need to put [“”] : ${StartMission}!=“” and ${EndMission}!=“” double not single.

Thanks again for your quick support.

[Kal_Lam]

@testwbd,