Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Michiel_QV_Fan
Specialist
Specialist

x% of total in sorted values

I need to calculate the x% items.

for instance:

ItemQuantiy
12
24
36
48
510
612

ordered by quantity and then the items that lead to 25% of the total

itemquantitycumulative
61212
51022
4830
36etc.
24
12
42

25% of total = 10,5 so my result should be: item 6

itemquantity
612
1 Solution
5 Replies
sunny_talwar

Michiel_QV_Fan
Specialist
Specialist
Author

browser issues, this happend before. Strange. Removed the duplicate entry

sunny_talwar

Are you looking to do this in the script or front end?

Michiel_QV_Fan
Specialist
Specialist
Author

Front end because it is dependent on the selections made.