I've got a series of fields that require me finding out the Max and Min values.

To obtain the maximum I used the field calculator on a blank field and used the following Python function:

max ([!field1!, !field2!, !field3!])

However... I realized that using the same for the min will me with a load of zero's.

I tried some if = 0 stuff, but didn't really know what I was doing (got nowhere).

I also tried to cheat by doing a find and replace with the fields (replacing 0 with <Null>), but that didn't even work...

My head is full of fluff this week and I'm struggling with this one. I'm sure there must be a simple way round this.

Can anyone suggest a solution...?

It would be really appreciated.

To obtain the maximum I used the field calculator on a blank field and used the following Python function:

max ([!field1!, !field2!, !field3!])

However... I realized that using the same for the min will me with a load of zero's.

I tried some if = 0 stuff, but didn't really know what I was doing (got nowhere).

I also tried to cheat by doing a find and replace with the fields (replacing 0 with <Null>), but that didn't even work...

My head is full of fluff this week and I'm struggling with this one. I'm sure there must be a simple way round this.

Can anyone suggest a solution...?

It would be really appreciated.

One way to do it: A list comprehension to zap the zeros before you run min():

So your Calculate Value expression could be: