topic Re: Making a response negative based on a previous response in ArcGIS Survey123 Questions

Making a response negative based on a previous response

HenryPittman — Fri, 18 Dec 2020 21:41:56 GMT

Hi, This seems like a simple question to me so hopefully someone can help me out before waste too much time working on it. I'm trying to make a decimal value ${Amount} negative based on the response to a previous select_one questions, Is the amount an expense or deposit? Simple enough I would think.

I used an if statement in the calculation column to try to accomplish this. Here is the syntax

if(selected(${Transaction_Type},'Expense'),-${Amount},${Amount})

This returns an error. I've tried variants of this syntax with no luck. Like I said seems simple enough. Am I just overlooking something simple or is there a better way to do this?

Thanks for the help,

Tyler

Re: Making a response negative based on a previous response

MicZatorsky_AEC — Sun, 20 Dec 2020 19:52:48 GMT

One solution is to use a second, read-only field. Working XLSX attached.

Re: Making a response negative based on a previous response

HenryPittman — Tue, 22 Dec 2020 15:16:32 GMT

Thanks so much I knew it was something simple. It didn't like the circular nature of trying to do the calculation in the same filed that the data was enter just wouldn't work. I ended up using it in a calculate question type to hide that from the user and all is well.

Thanks,

Tyler