Forum Discussion

av9's avatar
av9
Icon for Helper III rankHelper III
5 years ago
Solved

Remove commas on concatenated columns

I have three calculated columns, Customers, Accounts and Staff I want to concatenate into one ccolumn. I created this calculated column, but I notice the commas still appear if one of the three table...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    av9 , you can use if to control

    Attendees = Appointments[Customers] & if(isblank(Appointments[Accounts]),"" , ", " & Appointments[Accounts] )& if(isblank(Appointments[Staff]) , "" ,", " & Appointments[Staff])

  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi av9 

    Try this

     

     

    Attendees = Appointments[Customers]   &  if(len(Appointments[Accounts])>0,", " &  Appointments[Accounts] , "") & if(len(Appointments[Staff])>0, ", " & Appointments[Staff], "")

     

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi av9 

Try this

 

 

Attendees = Appointments[Customers]   &  if(len(Appointments[Accounts])>0,", " &  Appointments[Accounts] , "") & if(len(Appointments[Staff])>0, ", " & Appointments[Staff], "")

 

 

Phil