I'm hoping this is just a small syntax error. I'm trying to get a gallery to display records only when the value from a specific column is 1 or higher (basically, when one specific employee has at least one item in a given row/record checked out from the office). Currently the gallery works if I leave the code as simply drawing data from my collection ("OnHand," generated when I hit the "refresh" button), but if I try to filter as "Filter( OnHand, With_x0020_April > 0 )" I get an error that it was expecting a number value, and if I try "Filter( OnHand, With_x0020_April.Value > 0 )" I get a message that "." is invalid. Can anyone suggest an alternate syntax?
That's got it! Thank you both!
My first guess would be that With_x0020_April is not a number data type. Perhaps its text or something else. What happens if you do this>
Filter(OnHand, Value(With_x0020_April) > 0)
I know it will throw a delegation warning but do any results show in the gallery?
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Try Value(With_x0020_April) instead of just 'With_x0020_April'