Survey123 Formula Question (ABS)

Question

I am basically trying to replicate IF(ABS(D4)>(E2),"Yes", "No") this formula in my survey.

Values captured in the fields D4 and E2 has been populated from different calculation which can be positive or negative, Irrespective of that it should populate the result as Yes or No.

Thanks for the help in advance.

Anu

AnuSawant · Answer

Thanks James, its working exactly the same way I wanted it.

Anu

JamesTedrick · Answer

Sure,

The if() statement looks to see if the value of the question is less than 0.  If it is, it multiplies it by -1, resulting in a positive value the same distance away from 0.  If it is not, it returns the value, which is either 0 or a positive number. The result is that you always get a positive number or 0.

AnuSawant · Answer

Sorry James, but you would be able to elaborate more?