topic Re: Mathematical Calculation from a previous integer question in ArcGIS Survey123 Questions

Mathematical Calculation from a previous integer question

TrevorRobar2 — Wed, 13 Dec 2023 18:34:51 GMT

Hey Everyone,

Building out a form where my user will select a value from 1-14 in a question, and a calculation is performed based on this selection.

For my calculation question, I need to create a calculation based on the previous answer.

This is what I have so far.

if(${fee_type} = 1, (${new_sqft} * 0.15 + 50), 0, 0)

fee_type = integer

new_sqft = double

fee = double (Will be Calculated)

Any direction would be greatly appreciated, almost finished.

Thanks,

Trevor

DougBrowning — Wed, 13 Dec 2023 18:37:40 GMT

You have too many parameters - only 2 not 3. Not sure what that last 0 is.

if(${fee_type} = 1, (${new_sqft} * 0.15 + 50), 0)

if(condition, true, false)

Note set the bind::type column if you are seeing strings getting concat instead.

TrevorRobar2 — Wed, 13 Dec 2023 19:01:49 GMT

Nice Catch, Thanks! I knew if I stopped looking at it and asked a friend, it would work out.