Percent format?

Resolved

I can't seem to find the percent format? Is that not available? I want to format a formula result as a percent, not a decimal. Do I need to multiply by 100 and add the "%" suffix manually? Thanks.

Best reply by Nate Montgomery

Hi Tom Peterson. The ability to format formula field is planned on the roadmap. See here. Until this gets release, you can use a CONCAT() function to encase your formula field and add it with a percent sign. For example:

CONCAT( ( [Number Field 1]+[Number Field 2] *100) , "%")

View original

5 replies