Hey folks, I am using the old classic formula line...
# administration
c
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?
k
Try this formula instead - no promises
replace(ns_concat(to_char({amount},’$99,999,999.99’)), ',' , '<br>')
or This one
listagg(to_char({amount},'99,999,999.99'),'<br>') within group (order by {id}) over ()