Solved: Line break to remove if column is blank - Page 2

Moniker · 10-01-2024 03:27 PM

My current expression is
CONCATENATE(
if(isnotblank([WASHING]),Concatenate(Washing," - ",[WASHING]),"")&"
"&
if(isnotblank([DAMAGE]),Concatenate(Damage," - ",[DAMAGE]),"")&"
"&
if(isnotblank([Road Fare]),Concatenate(Road," - ",[Road Fare]),"")&"
"&
if(isnotblank([Others]),Concatenate(Others," - ",[Others]),"")
)

Steve

Or this:

SUBSTITUTE(
  CONCATENATE(
    LIST(
      IFS((0 <> [WASHING]), ("Washing - " & [WASHING])),
      IFS((0 <> [DAMAGE]), ("Damage - " & [DAMAGE])),
      IFS((0 <> [Road Fare]), ("Road - " & [Road Fare])),
      IFS((0 <> [Others]), ("Others - " & [Others]))
    )
    - LIST("")
  ),
  " , ",
  "
"
)

View solution in original post