Quote:
I would like a method to calculate the financial return if lowest performing products (e.g. those sold at Sale price) sold at Full price.
|
This is different from your first post in which you were asking for a method to calculate the gain if the lowest 10 performing products are sold at the mean price. Arvi's post answered your second post while I tried a roundabout solution for post #1. I hope it gives you an idea on how you finally get the exact answers that you need.