cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Class022 Frequent Visitor
Frequent Visitor

Concatenation of Percentage Columns

Hello,

 

I have four percentage columns as below and would like to combine them in a field similar to the picture on the right.

Untitled.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Concatenation of Percentage Columns

Perhaps something like:

 

Coins = CONCATENATE(CONCATENATE(CONCATENATE(CONCATENATE(CONCATENATE(CONCATENATE(FORMAT([Column2],"Percent"),"/"),FORMAT([Column3],"Percent")),"/"),FORMAT([Column4],"Percent")),"/"),FORMAT([Column5],"Percent"))

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


4 REPLIES 4
Super User
Super User

Re: Concatenation of Percentage Columns

Perhaps something like:

 

Coins = CONCATENATE(CONCATENATE(CONCATENATE(CONCATENATE(CONCATENATE(CONCATENATE(FORMAT([Column2],"Percent"),"/"),FORMAT([Column3],"Percent")),"/"),FORMAT([Column4],"Percent")),"/"),FORMAT([Column5],"Percent"))

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Class022 Frequent Visitor
Frequent Visitor

Re: Concatenation of Percentage Columns

Untitled.jpgThat worked very well, thanks!

 

Any chance I could format the percent with no decimals?

 

 

Super User
Super User

Re: Concatenation of Percentage Columns

I was trying that by wrapping each one in another FORMAT but wasn't having much luck with it. 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Class022 Frequent Visitor
Frequent Visitor

Re: Concatenation of Percentage Columns

OK, thanks anyway.  The format with the decimals will work fine.