Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table like this:
unit cost | quantity |
100 | 2 |
200 | 3 |
250 | 1 |
300 | 4 |
350 | 3 |
The result of a regular median function on unit cost is 250.
But I want to calculate the median according to quantity:
Median(100,100,200,200,200,250,300,300,300,300,350,350,350) Result: 300.
We do not want to use interval match becouse we have already millions of records.
Does anyone have a solution?
Thanks!
can you try this
AGGR(MEDIAN([Unit Cost]),Quantity)
or
AGGR(MEDIAN(total <unit cost>Quantity),Quantity)
Does not work.
median(total <Unit cost> Quantity)
Given 1.
You may try something like this:
=subfield(concat(repeat([unit cost] &',', quantity), ''), ',',
ceil(substringcount(concat(repeat([unit cost] &',', quantity), ''), ',') / 2))
- Marcus
Hi,
Does Anyone have an idea?
unit cost | quantity |
100 | 2 |
200 | 3 |
250 | 1 |
300 | 4 |
350 | 3 |
I have more dimensions.