×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Obtaining a value above a certain percentage

Obtaining a value above a certain percentage

Obtaining a value above a certain percentage

(OP)
Here's the setup.  I have a range of data that I would like to obtain the value above the minimum 10% of the varying range value.

                 Column
                   2
                   4
                   2
                   8
                   10
                   31
                   12

I am trying to eliminate the bottom 10% of values and get the next value up from this.  Any suggestions?

RE: Obtaining a value above a certain percentage

How is this different than your other problem with the >0 constraint replaced with >(0.1*(max(range)-min(range)))

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

RE: Obtaining a value above a certain percentage

(OP)
Your right.  Before I simply obtained a 10% value of my max and then used the >0 constraint with the value.  It was a two step process.  Your formula cleaned that up for me.  Thank you.



 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources