Creating a lookup table for pricing

I would like to show a production cost based on a quantity (number) entered by the user.
For example:
1000 = $2
The qty / costs would be associated with a specific product.
So if a user enters a qty. of 2500 they would get a cost of $3.00

How would I do this?

Yea sounds doable

Have a data type called Price Bracket. It contains a minimum quanatity (e.g 1000, 2000, 3000) and a price per unit.

Do a search for Price Bracket where minimum quantity <= user’s quantity input, sorted by quantity (descending) and take the first item’s price per unit.

Do a search for Price Bracket:first item's unitPrice

The price bracket search:
minimumQuantity <= Input quantity's value' Sorted by: minimumQuantity (descending)`

1 Like

This is excellent. Thank you!