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
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