Jump to content
Sign in to follow this  
sicSRT8

Lowest Numeric field but ignoring blank fields

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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 by Guest
typo

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Case(

IsEmpty( field2 ) ; field1 ;

Min( field1 ; field2 )

)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Will Xu 
×

Important Information

By using this site, you agree to our Terms of Use.