Announcements
Hi all
I have learned a lot, but I don't know how to code in the second filter to show only records that are greater than 0 in the reorder qty column.
Any help would be much appreciated.
Hey @Corissandageri
You can update the expression as:
FIlter(Table1,StartsWith(Supplier, Dropdown_Sup.Selected.Result) && CQuantity > 0)
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Thank you, but for some reason, I am still getting the squiggles under CQuantity. Telling me it's an invalid argument, expecting a number value.
HI @Corissandageri ,
Could you please share more details about the error message within your formula?
Could you please show more details about the "CQuantity" column in your Table1? Is it a Number column or a Text type column?
I have made a test on my side, please consider modify your formula as below:
Filter( Table1, StartsWith(Supplier, Dropdown_Sup.Selected.Result), Value(CQuantity) > 0 )
Please consider take a try with above solution, check if the issue is solved.
Best regards,
Thank you very much, this worked perfectly.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 88
WarrenBelz 85 Most Valuable Professional
Valantis 45
