topic Does Survey123 support the absolute value function? in ArcGIS Survey123 Questions

Does Survey123 support the absolute value function?

KaraHarmet — Wed, 31 May 2017 14:48:32 GMT

Hello,

Is it possible use the absolute value function in survey123? I need to formulate a logic statement based on the weight difference of two things. Example: "If the difference is > 0.3, the test fails." I have not seen any examples online showing absolute value. Any solutions or work arounds you know of would be greatly appreciated.

Thank you!

Re: Does Survey123 support the absolute value function?

IsmaelChivite — Wed, 31 May 2017 15:26:38 GMT

In the absence of the abs() function, will the above work for you?

You could keep the Calcu question as a 'calculate' and then use that variable in other expressions.

Re: Does Survey123 support the absolute value function?

KaraHarmet — Wed, 31 May 2017 16:40:09 GMT

This worked!!! Thank you so much!! Could you explain the language of the calculation in the 3rd row or point me toward a resource that would explain it? I'd like to understand it a bit further. Thank you!!!

Re: Does Survey123 support the absolute value function?

JamesTedrick — Wed, 31 May 2017 16:54:02 GMT

Hi Kara,

The statement says:

1) Treat the answer as text and look at the first character of the answer. See if it is a minus sign ( - )

2) If yes, grab everything in the answer except for the minus sign (from character in position 1 - *the second character* - to the end of the answer) and make that the value

3) In not, just give value of the question being looked at

the equivalent using numeric evaluation would be

if(${question} < 0, ${question} * -1, ${question})

Re: Does Survey123 support the absolute value function?

IsmaelChivite — Wed, 31 May 2017 16:59:07 GMT

Hi Kara.

I used operators and functions as described in this help topic: Formulas—Survey123 for ArcGIS | ArcGIS

Essentially:

substr() is used to extract portions of a string. I use it for example to extract the first character, which in our case could be either a minus sign (which we will want to remove later) or a digit. This function takes three inputs:
- The string from which you want to extract a substring
- The character position from which you want to start substracing
- The number of characters to remove
string-length() is used to calculate the total length of a string.
if(). the if statement allows you evaluate an expression. If the expression evaluates to true, you can output one value, and if it evaluates to false, you output another value.

There is no single way to solve this, as shown by James above. There may be other ways to solve it too.

Re: Does Survey123 support the absolute value function?

KaraHarmet — Wed, 31 May 2017 17:44:54 GMT

Thank you so much!

Re: Does Survey123 support the absolute value function?

KaraHarmet — Wed, 31 May 2017 17:45:26 GMT

Thank you!

Re: Does Survey123 support the absolute value function?

KaraHarmet — Fri, 02 Jun 2017 15:48:39 GMT

Just for future reference, if anyone comes across this...

Formulas—Survey123 for ArcGIS | ArcGIS

Under the calculations section they talk about the substr function.

Re: Does Survey123 support the absolute value function?

NicolasRoger — Mon, 07 Jan 2019 16:47:21 GMT

If you want to calculate it in a single Calculation field, you can also do the following:

sqrt(pow(${number1} - ${number2},2))

I squared the number and then took the square root. The result will always be positive.

Re: Does Survey123 support the absolute value function?

DeonLengton — Mon, 27 May 2024 13:00:15 GMT

Hi All

I found a better way to perform the Absolute math function.

pow(pow(${value},2),0.5)

By squaring a value and the finding its square root you are able to calculate the absolute of a value.