Quote:
Originally Posted by shanemarkley
It would be beneficial to see what the actual discount is ($1, $3, etc.) for the items that have a sale price. I was thinking about adding another column to the right of the "Retail" field called "Discount" where it calculates the dollar amount of the actual discount. Is this something that could be simply added to the "UpdatePrices" script we created?
|
Isn't that just the difference between the retail & LID prices? If so, you can do that calculation with a simple formula (eg =[@Retail]-[@[LID Cost]]) without any code.
Quote:
|
I am also thinking about adding another tab to this spreadsheet called "price comparison" that updates pricing when this scripts runs. This will allow the comparison (sorted lowest price to highest price) all spirit types based on what brand they are. Wine is probably too much to include in this but the majority of other categories would be beneficial to see the low to high cost.
|
That would be a lot of extra work, aside from which I'm not sure whether you mean, for example, 'Jim Beam' as a brand (which it is) vs 'Bourbon' as a brand (which it isn't, even though your worksheet lists it as such).