IVAN88 Posted April 26 Report Share Posted April 26 Hi, I have a table that record In-Out inventory transaction by batch number. My case : On Out transaction I want, user can only select product that still have a remaining quantity, I want to hide a zero quantity product. the remaining quantity will be group by batch number How can I do that ? Rgds, Quote Link to comment Share on other sites More sharing options...
0 Barry Posted April 26 Report Share Posted April 26 Hello Ivan, In the "Configure Filtering Fields" of the Report you can use comparisons with values. You could add the quantity there with the "Greater Than" type. Something like this: Quote Link to comment Share on other sites More sharing options...
0 ParkLoey Posted April 28 Report Share Posted April 28 Hi! Just wanted to share a reference where we can check what comparison types in report pages Caspio supports: https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/#:~:text=gmail.com”)-,Comparison Types,-The following is Quote Link to comment Share on other sites More sharing options...
Question
IVAN88
Hi,
I have a table that record In-Out inventory transaction by batch number.
My case :
On Out transaction I want, user can only select product that still have a remaining quantity, I want to hide a zero quantity product.
the remaining quantity will be group by batch number
How can I do that ?
Rgds,
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.