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?

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.