topic How to always round calculated integer UP to the next whole integer in ArcGIS Survey123 Questions

How to always round calculated integer UP to the next whole integer

Paulvan_Heerden1 — Mon, 04 Nov 2019 13:47:29 GMT

Hi there

I have a decimal field that I have calculated from the input that the field worker gave in another field. It is basically a calculation where the area entered by the field worker is divided by 5. The result of this calculation needs to be rounded UP to the nearest integer. So if the answer is 5.1, then the output must round up to 6.

How can I format this output to always round up to the next integer, no matter what the decimal value says? Obviously if the decimal value is 0 then the number won't round up.

Re: How to always round calculated integer UP to the next whole integer

DougBrowning — Mon, 04 Nov 2019 14:59:25 GMT

You could make it integer so they cannot type in a .?

Or a calculation of

if(${field}=0,0,int(${field})+1)

Re: How to always round calculated integer UP to the next whole integer

SteveLynch — Mon, 04 Nov 2019 15:36:01 GMT

add 0.5 before you cast to int.

Re: How to always round calculated integer UP to the next whole integer

DougBrowning — Mon, 04 Nov 2019 20:17:16 GMT

Why? That would mess up a value of say 5.9.

Re: How to always round calculated integer UP to the next whole integer

Paulvan_Heerden1 — Tue, 05 Nov 2019 05:44:08 GMT

Hi Doug, thanks for the reply. With the calculation that you gave me, I am not totally sure how I should use it in my case. I already have a calculation that I am doing in that field. You will see what I mean in the attached image. Can I use both expressions together? You will see that I am already dividing the input from a previous field to give me my answer. It is this answer that I need to have rounded up all the time

PS: I managed to get the formula you gave me working for my application, but the problem is that it add 1 to the answer even if it is a whole number. This means that if someone inputs 25 (which should give a result of 5), now gives you a result of 6 because 1 was added on to 25 to give you 26. This divided by 5 gives you 5.2, which then rounds up to 6 using the formula.

if((${effa} div 5)=0,0,int((${effa} div 5))+1)

I have also been playing with a mod and round expression, and I seem to have gotten it to work for me:

if((${effa} div 5) mod 1 < 0.5, round((${effa} div 5) + 0.5, 0), round((${effa} div 5), 0))

Re: How to always round calculated integer UP to the next whole integer

IsmaelChivite — Tue, 05 Nov 2019 12:23:38 GMT

Hi. This seems to be working for me. It is basically the same thing Doug posted plus a little twist to handle situations where people enter an integer value.

type	name	label	calculation	bind::type
decimal	effa	Input
calculate	effa5		${effa} div 5	decimal
integer	output	Output	if(int(${effa5})=${effa5},${effa5},int(${effa5})+1)

The XLSForm above will add a field into your feature layer called effa5. If you do not want that, simply set the bind::esri:fieldType column to null for effa5.

Re: How to always round calculated integer UP to the next whole integer

PrachiPatel — Fri, 14 Jan 2022 20:37:06 GMT

@Paulvan_Heerden1 it would be nice if survey123 had a RoundUp function. I have posted it as an idea , please kudo it up if you think it would be helpful
https://community.esri.com/t5/arcgis-survey123-ideas/add-roundup-amp-rounddown-as-mathematical/idi-p/1133982

Re: How to always round calculated integer UP to the next whole integer

AdrianMarsden — Fri, 13 Mar 2026 09:27:56 GMT

For info - this looks like it has improved since 2022

if(round(${_Priority2Total}, 0) < ${_Priority2Total}, round(${_Priority2Total}, 0) + 1, round(${_Priority2Total}, 0))

all described here How To: Use Calculations in Survey123 to Force Rounding up Decimal Values to Convert to an

If you are curious this is for a UK Asbestos Survey