Hey folks, I am using the old classic formula line replace(ns_concat({amount}), ',' , '<br>') in a saved search to collate all of the open transactions for a given customer into a single line on a save search return.
Unfortunately, I have to use either a numeric or a text formula to get the result I am looking for, rather than a currency formula.
I would really like to be able to format the result with two decimal places using something like
to_char(({amount}),’$99,999,999.99’) but marrying the two statements
replace(ns_concat(to_char(({amount}),’$99,999,999.99’)), ',' , '<br>')
is obviously an invalid expression. Is there a way to do this in a formula?