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

max calculate on 4 integer fields not returning the actual max integer

KatieWise

I created an integer field with a calculation to display the highest number from 4 other integer fields. So for field ${highest_number}, the calculation is max(${field1}, ${field2}, ${field3}, ${field4}). Using these numbers as an example: 450, 290, 875, and 1285; 875 is returned as the max number because I assume it starts with the highest number but obviously 1285 is the highest number. Any ideas on what is going on?

Find more posts tagged with

Accepted answers

BrittneyGibbons1

It seems to be parsing fields 1 - 4 as text instead of numbers. I would try forcing them to be read as integers using int(): max(int(${field1}), int(${field2}), int(${field3}), int(${field4})).

All comments

dougbrowning

You can also use the bind::type column set to int on the fields you want to check.

BrittneyGibbons1

Glad that worked! That happens to me all the time. Some fields that I expect to be numerical are processed as text instead, especially if I am using a select one with numerical values.

KatieWise

That did it! Thank you so much. I assumed it had something to do with that but wasn't sure the fix.

BrittneyGibbons1

It seems to be parsing fields 1 - 4 as text instead of numbers. I would try forcing them to be read as integers using int(): max(int(${field1}), int(${field2}), int(${field3}), int(${field4})).

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.