Skip to main content

Number to Text (Percent) in Concatenate

  • March 31, 2020
  • 2 replies
  • 41 views

Forum|alt.badge.img+4

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

Forum|alt.badge.img+18

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

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

Forum|alt.badge.img+11

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)