AnsweredAssumed Answered

How do you ignore cell with '0' in Min formula?

Question asked by Cheekychives on Nov 28, 2012
Latest reply on Nov 29, 2012 by Cheekychives
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.

Outcomes