On a transaction saved search can you write a formula that takes all "applying transaction" and lists them on a single column separated by a ,

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you cannot directly write a formula in a transaction saved search that takes all "applying transaction" and lists them on a single column separated by a comma. However, you can use a workaround by using a summary saved search and using the LISTAGG or NS_CONCAT functions to combine multiple rows into one. These functions are used to concatenate the values of the "applying transaction" field from multiple rows into a single string with each value separated by a comma. Here is an example of how you might use LISTAGG:

SQL
LISTAGG({applyingtransaction}, ',') WITHIN GROUP (ORDER BY {applyingtransaction})

And here is an example of how you might use NS_CONCAT:

SQL
NS_CONCAT({applyingtransaction})

Please note that these functions are used in the context of a SQL formula in a saved search, and the actual syntax may vary depending on the specific requirements of your saved search. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******