I am trying to calculate a fee based on a entered amount and I have that field set to a integer type. I am thinking possibly an if statement. if(${estValueofWrk} =1000 and${estValueofWrk} =50,000 and${estValueofWrk} =100,000 and${estValueofWrk} =16,166,666, then 50,000) I am lost, thank you to anyone that can assist me in advance.

if(${estValueofWrk} = 1000 and ${estValueofWrk} = 50000 and ${estValueofWrk} = 100000 and ${estValueofWrk} = 500000 and ${estValueofWrk} = 16166666, 50000, 0))))))

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need help with calculating fees with Survey123...using if statement maybe???

jeffhyderBRVA

I am trying to calculate a fee based on a entered amount and I have that field set to a integer type.

I am thinking possibly an if statement.

if(${estValueofWrk}<1000) then ${estValueofWrk} div 100) * 2 + 25) or if(${estValueofWrk}>=1000 and${estValueofWrk}<49,999 then ${estValueofWrk} div 1000) * 5 + 50) or if(${estValueofWrk}>=50,000 and${estValueofWrk}<99,999 then ${estValueofWrk} div 1000) * 4 + 250) or if(${estValueofWrk}>=100,000 and${estValueofWrk}<499,999 then ${estValueofWrk} div 1000) * 3 + 450) or if(${estValueofWrk}<500,000 then ${estValueofWrk} div 100) * 3 + 1500) or if (${estValueofWrk}>=16,166,666, then 50,000)

I am lost, thank you to anyone that can assist me in advance.

Find more posts tagged with

Accepted answers

DavidPike

if(${estValueofWrk} < 1000, (${estValueofWrk} div 100) * 2 + 25,
if(${estValueofWrk} >= 1000 and ${estValueofWrk} < 50000, (${estValueofWrk} div 1000) * 5 + 50,
if(${estValueofWrk} >= 50000 and ${estValueofWrk} < 100000, (${estValueofWrk} div 1000) * 4 + 250,
if(${estValueofWrk} >= 100000 and ${estValueofWrk} < 500000, (${estValueofWrk} div 1000) * 3 + 450,
if(${estValueofWrk} >= 500000 and ${estValueofWrk} < 16166666, (${estValueofWrk} div 100) * 3 + 1500,
if(${estValueofWrk} >= 16166666, 50000, 0))))))

All comments

DavidPike

if(${estValueofWrk} < 1000, (${estValueofWrk} div 100) * 2 + 25,
if(${estValueofWrk} >= 1000 and ${estValueofWrk} < 50000, (${estValueofWrk} div 1000) * 5 + 50,
if(${estValueofWrk} >= 50000 and ${estValueofWrk} < 100000, (${estValueofWrk} div 1000) * 4 + 250,
if(${estValueofWrk} >= 100000 and ${estValueofWrk} < 500000, (${estValueofWrk} div 1000) * 3 + 450,
if(${estValueofWrk} >= 500000 and ${estValueofWrk} < 16166666, (${estValueofWrk} div 100) * 3 + 1500,
if(${estValueofWrk} >= 16166666, 50000, 0))))))

ZachBodenner

Take a look at this community thread: https://community.esri.com/t5/arcgis-survey123-questions/conditional-if-then-else-logic-in-survey123-using/td-p/1038824

Survey123 doesn't use quite the language you'd expect. There's no "then" for example. Doug does a good job showing how an if statement could work here.

jeffhyderBRVA

That worked perfectly, now how do I format it that it will return the value in $##,###?

DavidPike

I'm not sure there is anything built-in to do it. There's a way mentioned here

https://community.esri.com/t5/arcgis-survey123-questions/in-survey-123-connect-is-there-a-way-to-format-the/m-p/740717

jeffhyderBRVA

Well after some testing it is not quite working perfectly. When I put in like 1,700,000 it is calculating 52500 if I put in 1,100,000 it calculates 34500. I currently have my set as a text maybe I should have it set as an integer?

DavidPike

That seems to be correct values from the logic of the first question. What are you expecting as the results?

(1,700,000 / 100) * 3 + 1500 = 52500

(1,100,000 / 100) * 3 + 1500 = 34500

jeffhyderBRVA

I got it figured out, one of the div was a 100 and not 1000 and it was throwing everything for a loop.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.