Skip to main content
Computes the bin for a value using the provided lower bounds Category: math Syntax: 
BinRange([value], [cutoff1], [cutoff2], ...)
Returns: Integer Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
valuenumber or column✓ YesThe value to place into the defined bins
cutoffsnumber✓ YesThe lower bounds to compare the value against. The first cutoff indicates the lower bounds of bin 2
Allowed Column Types for value: INT, FLOAT, DECIMAL

​
Validation

  • Minimum parameters: 2
  • Maximum parameters: 10

​
Examples

BinRange(25, 50)
Returns 1. All numbers lower than 50 are placed in bin 1 and all numbers 50 and greater are placed in bin 2 Result: 1 
BinRange([Income], 100000, 500000)
Incomes less than 100,000 are placed in bin 1; incomes 100,000 – 499,999 are placed in bin 2; incomes 500,000 and greater are placed in bin 3
Last modified on March 13, 2026