Product price by lookup table

  • In this example we calculate the product price using a lookup table bind on the product quantity.
    Here is the csv table used in this example:
    quantity 1 10 100 200 300 400 500 max
    1 100 95 87 79 72 64 57 45
    This translates to this:
    quantity 1 2-10 11-100 101-200 201-300 301-400 401-500 501+
    100 95 87 79 72 64 57 45
Category: