in an inventory balance saved search i want to create a filter that checks if the inventory number ends with 24

AI generated answer (using internal Slack threads):

To create a filter in an inventory balance saved search that checks if the inventory number ends with 24, you can use a formula (text) field in the criteria section of the saved search. Here's how you can do it: 1. Navigate to the criteria section of the saved search. 2. Click on 'New Criteria' and select 'Formula (Text)'. 3. In the formula field, enter the following formula:

RIGHT({inventorynumber},2)

. 4. Set the operator to 'is'. 5. In the value field, enter '24'. This formula checks the last two characters (rightmost) of the inventory number and compares it with '24'. If the inventory number ends with '24', the item will be included in the search results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******