There are two fields that need to be added to get ...
# ask-stanley-ai
d
There are two fields that need to be added to get the total number of records between thoae two fields in saved search. What will be the formula?
c
AI generated answer (using internal Slack threads):
To get the total number of records between two fields in a saved search, you can use a formula field in the results tab of the saved search. The formula would be
COUNT({field1}) + COUNT({field2})
. This formula will count the number of records in each field and then add them together to give you the total number of records between the two fields. Here is how you can do it: 1. Go to the Results tab of your saved search. 2. Click on 'New Field'. 3. In the 'Summary Type' dropdown, select 'Formula (Numeric)'. 4. In the 'Formula' field, enter
COUNT({field1}) + COUNT({field2})
. Replace
field1
and
field2
with the actual field IDs you want to count. 5. Click 'OK' to save the new field. This will add a new column to your saved search results that shows the total number of records between the two fields. ****** 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.857137382
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848157
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.847351909
Please provide your feedback on this answer.