I have a count on the number of supplier items. I have to give the supplier points from 0-100, where a low number of items means higher points and a high number of items means a low score. The min. value of items is 1 and the max. value is 3.000.
Supplier A: 1 items (100 points)
Supplier B: 3.000 items (0 points)
Supplier C: 5.000 items (0 points).
Maybe someone can help me.