Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Converting Percentage

Topic Labels: Formulas
Jump to Solution
920 3
Showing results for 
Search instead for 
Did you mean: 

I have a Rollup field that takes a series of decimal percentages from another table (e.g .68%, .72%, and .55%) and then calculates the average (.65%). I have the formatting of this field as Percentage and precision of 1.00. Unfortunately, when Airtable passes that result to the 3rd party app I am using (Stacker), it includes more than 2 decimals. I want to stop the number of decimals at 2. I think I probably need to convert this percentage to a string and then concatenate it with %. Anybody know of an easy formula to do this? Or a different solution?

1 Solution

Accepted Solutions

Nevermind. I figured out a solution.

See Solution in Thread

3 Replies 3

Nevermind. I figured out a solution.

what’s your solutions? :slightly_smiling_face:

Well, it’s not pretty or complex and it’s a hassle but it works. I had to create and use this formula: {FieldName} * 100 where FieldName is the rollup field and FieldName2 is the new field with the formula. I then created a 3rd field called FieldName3 and used: ROUND({FieldName2,2) / 100. This is what worked for me and now when I used FieldName3 in Stacker it only shows the 2 decimals. So basically, 3 fields instead of 1 field. :roll_eyes: But I figured out a solution and got it to work which is quite satisfying being new to Airtable.