AnsweredAssumed Answered

Is it possible for min() to return the smallest value based on more than two fields?

Question asked by Carmelce on Oct 6, 2016
Latest reply on Oct 6, 2016 by Carmelce

Is it possible for min() to return the smallest value based on more than two fields?

 

In our survey, multiple health and safety assessments of issues are collected for one site. Each assessment has a due date for a resolution of the issue. For analysis of the feature service in Web AppBuilder (charting/timeslider), I've created a new field in the survey that'll shows the earliest due date from the multuple due dates filled out in the survey. This calculation is then applied using the min() formula:

min(${DueDate1},${DueDate2},${DueDate3},${DueDate4}})

 

But what I've found is that this only ever takes the first 2 due dates into consideration and it ignores the other fields.

Is this just how min() works or do I need to add in an extra step?

 

Thanks!

 

Carmel

Outcomes