string-length expression on decimal value returns 0

[Anne-MarieDubois]

Hello,

I'm trying to use an expression to evaluate if a decimal field is empty or not in Survey123. I have found this option :

(string-length(${latitude}))>0

Unfortunately, this returns the "string-length(${latitude})" portion of this expression returns a value of 0 whenever I try to enter a decimal value.

Example: decimal not working

example: integer works

I have tried these altenatives without sucess:

• (string-length(number(${latitude})))>0
• (string-length(number(${latitude})))>0.0
• ${latitude} != 'NaN'

Can anyone help me finding a way to identify empty decimal fields ?

Kind regards,

Anne-Marie

[DougBrowning]

Checking on numbers can get tricky.  Have you tried ${latitude} != '' yet?  Any empty field is usually empty string, even numbers.

[Anne-MarieDubois]

Yes I tried that already and it does not work.

[DougBrowning]

What about = 0 or != 0 that sometimes works for me.

[Anne-MarieDubois]

That doesn't work either. The thing is is that the available expressions don't seem to make a diffrence between an empty field OR a decimal field.

[DeonLengton]

Hi

Try first converting it to a string and then checking it's length:

string-length(string(${latitude}))=0

[Anne-MarieDubois]

Still same issue. It only works for integers.