Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
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.
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.
Jan 30, 2022 02:25 PM
What is your formula? All parts of your formula must result in a number (or be blank) in order to format it numerically.
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:
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.