Find MIN excluding zero's

[Simon UK]

Hi,

 

I'm looking to calculate the min value from 4 fields in a record but want to exclude zero values except where the fields are all zero values.

 

I'm very confused and would appreciate any pointers on this.

 

Best regards,

 

Simon

[comment]

Try perhaps:

Let ( [
a = Case ( FieldA ; FieldA ) ;
b = Case ( FieldB ; FieldB ) ;
c = Case ( FieldC ; FieldC ) ; 
d = Case ( FieldD ; FieldD )
] ;
Min ( a ; b ; c ; d )
)

There's very likely something wrong with your structure if you need this. For one thing, you should not have 4 identical fields. For another, if 0 doesn't count, the field should be empty (that's what the calculation above does).