DDM
01/14/2025, 11:01 PMCeligo AI
01/14/2025, 11:01 PMAI 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.
******Celigo AI
01/14/2025, 11:01 PMSlack 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
Celigo AI
01/14/2025, 11:01 PM