Hello all,

Im creating a saved search with a formula field to concatenate the transaction number of 2 bills in the memo field of a payment.

The formula below is getting the transaction number repeated, there is a way to select the first row and them concatenate with the second row?

CONCAT((CASE WHEN {appliedtotransaction.type} = ‘Bill’ THEN {appliedtotransaction.transactionnumber} ELSE NULL END),

(CASE WHEN {appliedtotransaction.type} = ‘Bill’ THEN {appliedtotransaction.transactionnumber} ELSE NULL END))

Thanks!
This is a cached copy. Click here to see the original post.