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; } } }

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

Paulvan_Heerden1

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.

Find more posts tagged with

Accepted answers

All comments

dougbrowning

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

Or a calculation of

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

SteveLynch

add 0.5 before you cast to int.

dougbrowning

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

Paulvan_Heerden1

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 What my field looks like in the spreadsheet

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))

IsmaelChivite

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.

PrachiPatel

@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

AdrianMarsden

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

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.