Simple formula for bin aisles

What I am looking for is a formula to filter results to display {aisle.number}  only on those labeled >= 100. I’m trying:
CASE WHEN {aisle.number} > 99 THEN {aisle.number} ELSE NULL END

Though this generates ERROR: Invalid Expression


Rookie Asked on April 1, 2022 in Saved Searches.
Add Comment
1 Answer(s)

Run a formula with just {aisle.number} and make sure that is pulling the expected results. If not, you may need to pull that information from a different field. (I don’t have bins/aisles in any of my accounts so can’t check for you)

Assuming the above worked, {aisle.number} may be coming out as text. Use the TO_NUMBER() expression to convert it to a number so you can do math on it and see if that works.

Intermediate Answered on April 6, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor