In my transaction saved search, I'm trying to format the GL account to this: Account Number if any <space><hyphen><space> Child Account Name My formula is below and shows incorrect result for parent accounts. It duplicates the Account Number for those parents. CASE WHEN {account.number} IS NOT NULL THEN CONCAT(CONCAT({account.number},' - '),LTRIM(regexp_substr({account},'[^:]*$'))) ELSE LTRIM(regexp_substr({account},'[^:]*$')) END