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.
This should do it. int(${num_types} div 1000) + 1
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
@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...