Give me an example of a formula I can use to filte...
# ask-stanley-ai
m
Give me an example of a formula I can use to filter down the transactions saved search to specific internal IDs.
c
AI generated answer (using internal Slack threads):
To filter down the transactions saved search to specific internal IDs, you can use a formula in the criteria section of the saved search. Here is an example of how you can do it: 1. Go to the Criteria tab of the saved search. 2. Click on 'Formula (Numeric)'. 3. In the formula field, enter the following formula:
CASE WHEN {internalid} IN (12345, 67890, 111213) THEN 1 ELSE 0 END
4. Set the operator to 'equal to' and the value to 1. This formula will filter the saved search to only include transactions with the internal IDs 12345, 67890, and 111213. You can replace these IDs with the ones you want to filter by. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.853813052
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.851508737
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.850307465
Please provide your feedback on this answer.