AnsweredAssumed Answered

Max function

Question asked by GJBDJC on Mar 6, 2017
Latest reply on Mar 6, 2017 by fmpdude

Seem to be having trouble with the MAX function

 

I have a table SHIFT INFORMATION and a field CONTAINER NUMBER, the container number field will vary in sequence.

Here are three examples: I'm looking for the highest number, the example below would yield 4, 30 or 7 respectively.

All fields are number fields or are set to result in a number and contain nothing but numbers.

Container Number

1          1          1    

2          10        3 

3          20        5

4          30        7

 

I created a calculation field using MAX(Container Number) in the same table... I get nothing?

 

Seems too straight forward for me to screw up?

Outcomes