Forum Discussion
AbbasG
Memorable Member
Memorable MemberCalculating price difference between suppliers
Hello All,
I have the data where I have the prices from different suppliers as below.
I want to display the Model number in a separate table where the Price of supplier 1 is at least lower by 10% as compared to the other 4 suppliers.
| Model | Description | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4 | Supplier 5 |
| A | test product | $160 | $145 | $130 | $180 | $140 |
| B | test 2 product | $220 | $185 | $195 | $180 | $220 |
4 Replies
- lbendlin
Super User
Your sample data does not support your problem description. Please provide sample data that fully covers your scenario.
- AbbasG
lbendlin Thank you for the reply.
Let me try to explain it again. The sample data is correct as below.
Model Description Supplier 1 Supplier 2 Supplier 3 Supplier 4 Supplier 5 A test product $160 $145 $130 $180 $140 B test 2 product $220 $185 $195 $180 $220 Now, I want to compare the price of supplier 1 with other suppliers.
If the price of supplier 1 is lower by at least 10% as compared to other suppliers, I want to highlight that Model no.
Thank you in advance for your kind help.- AbbasG
amitchandak Pragati11 If you guys help me with this, please?
