This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Formatting percentage numbers in a formula

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Topic Labels:
Formulas

Solved

Jump to Solution

0
2418
4

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 30, 2022 01:27 PM

Hi there,

Let’s say I have a formula field - Field A - that produces a decimal value (e.g., 0.5).

I use the formatting option within the formula field to display this value as a percentage.

However when I call that field in another formula - Field B - it is displaying using the original decimal value.

Is there a way to format my the ouput in Field B, so that it displays as a percentage value?

Currently Field B is outputting data like:

0.5

0.8333334

0.2

I want Field B to output:

50%

83%

20%

If anyone could help that would be much appreciated!

Solved! Go to Solution.

1 Solution

Accepted Solutions

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 30, 2022 02:58 PM

You need to round the number to get rid of the extra decimal places.

```
CONCATENATE(
ROUND(
{% Calc} * 100,
0
),
"% Text"
)
```

If you have more complex needs when converting a number to a text string, you can use my Ready Made Formulas app with a premium license.

Reply

4 Replies 4

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 30, 2022 02:25 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 30, 2022 02:32 PM

Hi Scott,

Field B is going to output both text and numbers.

So, for example it currently shows:

{% Calc} & " Text"

This then outputs:

`0.833334 Text`

But I would like it to output:

`83% Text`

I had tried this formula to manually alter the format:

`({% Calc} * 100) & "% Text"`

But it still shows all the extra decimals and outputs:

`83.3334% Text`

Any help would be great :slightly_smiling_face:

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 30, 2022 02:58 PM

You need to round the number to get rid of the extra decimal places.

```
CONCATENATE(
ROUND(
{% Calc} * 100,
0
),
"% Text"
)
```

If you have more complex needs when converting a number to a text string, you can use my Ready Made Formulas app with a premium license.

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 30, 2022 03:17 PM

Thank you @kuovonne , this worked perfectly!

Reply