Maybe its just Friday and my brain is off for the 3 day weekend, but I'm totally struggling with this issue.
I need to sum the values of the units sold, but I can only sum the value up to the total units replaced. Dropping off the lowest values.
So I need to rank the highest unit value and multiply the units sold times that value up to the total units replaced.
<colgroup><col span="3"><col><col><col></colgroup><tbody>
</tbody>
I need to sum the values of the units sold, but I can only sum the value up to the total units replaced. Dropping off the lowest values.
So I need to rank the highest unit value and multiply the units sold times that value up to the total units replaced.
rank | value | units sold | unit value | units replaced | |
3 | 400 | 2 | 200 | 4 | |
2 | 1750 | 5 | 350 | ||
1 | 1200 | 1 | 1200 | ||
Total | 3350 | 1750 |
<colgroup><col span="3"><col><col><col></colgroup><tbody>
</tbody>