Skip to main content
Qargo

Rate card FAQ: how to use a Between filter for a range of values

Using a Between filter (end exclusive / end inclusive) in a rate table affects how ranges are applied.

Q: A rate table was created using a range of values (or tiers), and it does not rate as expected. The ranges are off or missing altogether. Why?

A: Check how the rate table ‘Between’ filters have been set up in the table.

When a range of values is used to build a rate table, there are 2 ‘Between’ filter options to choose from. Ranges can represent anything from a ZIP code to a quantity or distance value. When available, the 2 filter options show as ‘Between (end exclusive)’ and ‘Between (end inclusive)’.

  • End exclusive: This excludes the end value entered in the range

    • Example

      • 0–700 = 0–699
      • 701–1400 = 700–1399
  • End inclusive: This includes the end value entered in the range

    • Example

      • 0–700 = 0–700
      • 701–1400 = 700–1400

Q: How are the ‘Between’ filters used if the values include decimal points?

A: To avoid decimal gaps, determine which tier the value should fall into and use the appropriate ‘Between’ filter to accommodate it.

Example:

  • If 700 needs to fall into the first tier:
    End inclusive
    0–700
    700–1400

  • If 700 needs to fall into the second tier:
    End exclusive
    0–700
    700–1400