what formulas can i use in a workbook that shows all related previous transactions for each payment in a list on single row

AI generated answer (using internal Slack threads):

To create a workbook that shows all related previous transactions for each payment in a list on a single row, you can use the

LISTAGG

or

NS_CONCAT

functions in your formula. These functions are used to combine multiple rows into one. Here is an example of how you can use these functions:

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

or

SQL
NS_CONCAT({transaction})

These functions will concatenate all the transaction values into a single string, separated by a comma. You can also use the

CASE

statement in your formula to handle different conditions. For example:

SQL
CASE WHEN {paidtransaction} != '' THEN {paidtransaction} ELSE {payingtransaction} END

This formula will return the

paidtransaction

if it's not empty, otherwise, it will return the

payingtransaction

. Remember to replace

{transaction}

,

{paidtransaction}

, and

{payingtransaction}

with your actual field identifiers. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******