Lowest Numeric field but ignoring blank fields

[sicSRT8]

I have two fields displaying numbers. Field 1 and Field 2.

How would I get Field 3 to show the lowest numeric number from either field 1 or field 2 but ignoring fields that are blank.

Whats the smallest value out of 1 and 2 ___Field 3___

Number Field ___Field 1___

Number Field ___Field 2___

Anyone Help with this?

[mr_vodka]

Min (Field1; Field2) ?

I am not sure what you mean by ignore fields that are blank. Do you mean that you do not want anything returned if both fields are empty, one field is empty, etc?

Edited April 24, 2009 by Guest
typo

[sicSRT8]

One field empty. Field one will always have a value but field 2 will only have a value smaller than one. I guess it could also work to use field 2 if there is a value as it will always be smaller than field 1.

[Fitch]

Case(

IsEmpty( field2 ) ; field1 ;

Min( field1 ; field2 )

)