Saved Search > To Determine if Kit/Package Items is Available using Formula

To create Item Saved Search:

1. Navigate to Lists > Search > Saved Searches > New > Item
2. In Criteria tab > Standard subtab, add:
- Type is Kit/Package
3. In Results tab > Columns subtab, add:
- Name | Summary Type: Group
- Formula (Text) | Summary Type: Minimum | Formula = Case When Min({memberitem.quantityavailable}/nullif({memberquantity},0)) > 0 then 'YES' Else 'NO' End
4. Modify the Search Title
5. Click Save & Run