Concatenation of Percentage Columns

[Anonymous]

Hello,

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

[Greg_Deckler · Accepted solution]

Perhaps something like:

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

[Anonymous]

That worked very well, thanks!

Any chance I could format the percent with no decimals?

[Greg_Deckler]

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

[Anonymous]

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

[Susan513]

I was doing a similar thing today - I found if I put "0%" instead of "Percent" I was able to get the value without decimals. Hope this helps someone!