Percentage help!

Topic Labels: Formulas
498 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hey guys,

I just started using AirTable today and i'm going crazzy on how to set up a percentage formula.
I have column A which is named goal (set up as number), column B, which is names Actual (also set up as a number field), and column C which is the variance of the two. I'm trying to create a 4th column which would show me the variance in percentage and would be great if I would be able to also show it as a progress bar. 

Now, I have figured out the percentage bar, but how do I get the actual percentage instead of me having to calculate it every time?

Is it actually doable?
I have included a screenshot so you guys can better understand me 🙂

Thank you everyone!

Screenshot 2023-08-25 234152.png

2 Replies 2

I believe it should be as simple as Actual/Goal with format set to percent.

Hi BillH,

Thank you for your reply, but that is what I have been trying to do so far, but does not seem to work. 

At this point I'm thinking I'm not writing the formula correctly and it's not complete?

Thank you 🙂