Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Number to Text (Percent) in Concatenate

Topic Labels: Formulas
2610 2
cancel
Showing results for 
Search instead for 
Did you mean: 
CAHerrmann
7 - App Architect
7 - App Architect

I imagine there is a simple way to do this, but I need to convert a decimal number to a text percentage (0.15 > 15%) to incorporate into a concatenate formula.

2 Replies 2

In the field you are concatenating it in, you should be able to just insert something like this:

... & ({Field with Decimal Percentage} * 100) & "% " & ...

Sharing another version:

LEFT(ROUND({Field with Decimal Percentage}*100,2) & “%”,7)