Rounding to the nearest whole integar

Question

I have a calculation inside of Survey123 for a particular question. My equation right now is:

if(contains(${sub_section}, '704.03.02', ${num_types} div '1000', "")). my field type is Integer on Survey123

So if a user enters 2200 in this field and the calculation would technically return 2.2 if that value is divided by 1000. So the output of the formula is "2" since it is an integer field. .

Is it possible to include a RoundUp function to the next number so that anything over a whole number would increase by 1? if the value was 2.1 then round to 3.. if the value is 2.9 round to 3.

PrachiPatel · Answer

@JohnnyHarley232  It sure would be nice to have a RoundUp function. I have added it as an idea. Give it kudos if you think that would be helpful
https://community.esri.com/t5/arcgis-survey123-ideas/add-roundup-amp-rounddown-as-mathematical/idi-p/1133982

IsmaelChivite · Answer

The round() function may work for you. For example: round(${aNumber},0) will round up a number to 0 decimal numbers and round(${aNumber},1) will round it to a number with 1 decimal

dougbrowning · Answer

This should do it.   int(${num_types} div 1000) + 1