formula to show the item for the amount in the sum...
# ask-stanley-ai
n
formula to show the item for the amount in the summary saved search
c
AI generated answer (using internal Slack threads):
To show the item for the amount in the summary saved search, you can use a formula in the Results tab of the saved search. Here's a general approach: 1. In your saved search, go to the Results tab. 2. Click on 'New Field' to add a new column. 3. In the 'Summary Type' dropdown, select 'Group'. 4. In the 'Field' dropdown, select 'Formula (Text)'. 5. In the 'Formula' field, you can write a formula to display the item for the amount. For example, you can use the following formula:
CASE WHEN {amount} = YOUR_AMOUNT THEN {item} ELSE NULL END
. Replace
YOUR_AMOUNT
with the amount you are interested in. 6. In the 'Label' field, enter a name for your new column. This will create a new column in your saved search that shows the item for the specified amount. Please note that you need to replace
YOUR_AMOUNT
with the actual amount you are interested in. ****** 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.862163603
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.85148406
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.846501291
Please provide your feedback on this answer.