Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to build an expression that will take a series of expression results and give me the sum of the top X results. X will be based on number Y.
For example, take this set of results:
Occurrence | Value |
39537 | 118556.10 |
24570 | 115666.24 |
38604 | 48317.64 |
40729 | 31146.74 |
28534 | 5408.67 |
32292 | 2608.14 |
36582 | 1959.76 |
50463 | 1900.01 |
32461 | 1716.10 |
28001 | 1627.92 |
28777 | 1316.53 |
36647 | 1211.20 |
If number Y was 100,000, I need the expression to return 118,556.10 for X. If number Y was 200,000, I need the expression to return 234,222.34 for X.
I am trying to return the point at which the sum of values (X) fully exhausts a fund (Y). The variance of these numbers (18,556.10 and 34,222.34 respectively in the examples above) is the figure I need. If the calculation does not sort descending as it is processed, the variance will not be correct.
The place I'm getting stuck is in identifying the limit in the sort order as a returned value. If I can find the break point, I can then use that figure to cap the sum or apply some kind of ranking.
Hopefully that made some sense. Any suggestions would be greatly appreciated!!
I may be getting closer, but still can't find a way to have the calculated range accumulate internally. I can use concat to get the range of values returned in descending order, but when I use above to get the accumulating values, they aren't coming in descending order. Any suggestions?