Jump to content

Find MIN excluding zero's


This topic is 2586 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

This topic is 2586 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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