I want to remove NaN from the Form

User Support Form Building
,
1

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

2

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

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

3

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!

4

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

5

Dear concern,

I have attached my XLSForm. Please see

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

6

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

image
image1135×588 32.6 KB

Reference XLSForm:

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

7

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

1 Like
8

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

Thanks again for your quick support.

1 Like
9

@testwbd, :clap: :heart: :partying_face:

10

Hi, In default response I put Zero (0) as default value. Now its solved.

1 Like
11

@testwbd, :tada: