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
Thanks.
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.
