Skip to main content
andrewh0007
andrewh0007Answer
Inspiring
Apr 27, 2022 6:59 AM UTC

a!localVariables(
  local!numberOne: 17,
  local!numberTwo: 5,
  if(
    local!numberOne = local!numberTwo,
    {},
    a!localVariables(
      local!lowerNumber: min(
        local!numberOne,
        local!numberTwo
      ),
      local!upperNumber: max(
        local!numberOne,
        local!numberTwo
      ),
      local!difference: local!upperNumber - local!lowerNumber - 1,
      1 + local!lowerNumber + enumerate(local!difference)
    )
  )
)

View in thread

2 replies

andrewh0007
andrewh0007Answer
Inspiring
Apr 27, 2022 6:59 AM UTC

a!localVariables(
  local!numberOne: 17,
  local!numberTwo: 5,
  if(
    local!numberOne = local!numberTwo,
    {},
    a!localVariables(
      local!lowerNumber: min(
        local!numberOne,
        local!numberTwo
      ),
      local!upperNumber: max(
        local!numberOne,
        local!numberTwo
      ),
      local!difference: local!upperNumber - local!lowerNumber - 1,
      1 + local!lowerNumber + enumerate(local!difference)
    )
  )
)

    stewart.burchell
    stewart.burchell
    Employee
    Apr 27, 2022 10:18 AM UTC

    If by "between" you mean "including the lower and upper values" then this would work for you:

    if(
  ri!lower > ri!upper,
  fn!tointeger({}),
  fn!enumerate(ri!upper - ri!lower + 1) + ri!lower
)

    ...where ri!upper and ri!lower are integer values.

    If you want to exclude the lower/upper values then that would be a small tweak to the above code.

    Terms & ConditionsAccessibility statement