Display % allocation as % not as a decimal

stuartr_66

I have created a join of Project + % allocation columns below to display as a helpful string in a timeline view.

However the join displays the % allocation as a decimal ie 0.4 rather than 40% which I would prefer.

% allocation column is formatted as a %.

The formula I'm using is =JOIN(Project@row:[% allocation]@row, " - ")

Is there an easy way to change/modify the join formula to support this?

Protonsponge

Hello @stuartr_66,

One option could be to multiply the value in your [% allocation] column by 100 and then add the "%" symbol. You can do this in one formula as per below which should be one way to achieve what you are looking for.

=JOIN(Project@row + " - " + ([% allocation]@row) * 100 + "%")

I hope that is helpful to you in some way,

Protonsponge

stuartr_66

Thanks @Protonsponge that's extremely helpful. I've just used that now.