We help IT Professionals succeed at work.
Get Started

Percentage Ranking = Points

326 Views
Last Modified: 2021-04-21
I would like to sort a list of data where all data respresents 100% and then would like to allot each data the full-percentage-point (uprounded) in a separate field like

Symbol          P1_1           [%]                               F1_1
abc                0.15            0.02%                          1
aed                0.16            0.04%                           1
....
edx                5.43            97.9%                           98
bde                6.15             100%                           100

I call the data by
SELECT     Symbol, P1_1
FROM         dbo.GFHilfstabelleV1
WHERE     (NOT (P1_1 IS NULL))

and would like to SET F1_1 later with the points. As there are always some outlier, would there be a way to skip the first/last half percent from the ground data?

No idea if my thoughts can be placed in a code but appreciate any ideas
thx
Kongta
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 30 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE