Unable to use decimals in calculation

Question

Hello 😀 !

I am facing a problem with decimals, in my Survey123 project, the operator must enter a decimal number in a field. Later in the formular, the entered value is used in a calculation, but it doesn't work ! I tried to diplay the value in another field to see if there's a problem with it. It seems like when the value is an integer (e. g. "8"), there's no problem, but when a decimal value is entered (e. g. "3.2"), nothing happen, like if the value was not considered at all.

I recreate my problem in the following formular :

When the entered number is an integer, here "10", I am able to display the value and use it in a calculation :

When the entered number is a decimal, here "2.3", nothing happen :

I would be extremly happy if one of you could help me !

my version of Survey123 is 3.9.120

Amaury

ChampionAmaury · Accepted Answer

Thank you for your answer ! I found a solution through your idea. I replaced the "type" from "decimal" to "text" then I can use the command number(...) to use the value as a number

dougbrowning · Accepted Answer

Be aware doing it this way means the field will be stored as text which may be a pain later when using the data.

Inside the form 123 defaults to text esp on notes.  You can set the bind::type field to decimal and then it will work as you wanted.  If you want the database note to be decimal also you can also set the bind::esri:fieldType column.

Hope that helps