Hello,

I have a saved search for Projects, where I am also extracting Unique Sales Order and SO Total Amount information. Formula used for the same

REPLACE(NS_CONCAT(DISTINCT(CASE WHEN {transaction.type} = 'Sales Order' THEN ({transaction.number} || ':' || {transaction.totalamount} ) END)),',','<br>
')

the same is extracted in 2 different columns SO and SO Amount, in case of 2 SOs with same amount, the amount column shows only 1 amount. So decided to concatenate SO and SO Amount and then extract the unique records. This gives following results:

TESTSO0001:600000<br>TESTSO0002:300000

As user wants to see SO and SO Amount in 2 separate columns with unique SO and associated amount. For amount column, is there a way to extract 2 amount fields like