This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello can anyone correct this formula? it's not working.
replace(ns_concat(case when {accounttype} != 'Cash' then {class} when {accounttype} != 'Accounts Payable' then {class} end),',','&lt;br&gt;')

`LISTAGG(Decode({accounttype}, 'Accounts Payable','','Cash','',{class}),'&lt;br&gt;')` edited per michoel comment below

For what it's worth I'm not sure "cash" is an account type. I think you mean bank

Also you can use `LISTAGG` instead of `NS_CONCAT` if you need a custom delimiter -
`LISTAGG(DECODE...., '&lt;br&gt;')`

sorry. I meant bank. anyways, thank you! it works :slightly_smiling_face:

hello do you have any idea why is it showing for this account only and not with the other accounts?