Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Just can't understand a basic percentage operation

Topic Labels: Formulas
Solved
Jump to Solution
442 1
cancel
Showing results for 
Search instead for 
Did you mean: 

percentage airtable

The funny part is that when I change the data type in field in question from a formula to a plain decimal number - it all works! Does Airtable not support this kind of calculation when the primary field is a formula deriving data from another formula, or I am doing something wrong?

1 Solution

Accepted Solutions

How are you calculating the {Total #of questions}? What field types does the formula pull its data from?

It looks like the {Total #of questions} formula is returning a string value, instead of a number. Notice that it is left aligned, instead of right aligned.

You can wrap the {Total #of questions} field in the VALUE() function to force it into a number. Then the calculations should work.

However, even if that works, you might want to revisit the formula for {Total #of questions} to better understand what is going on.


If this answers your question, please mark this post as the solution. Otherwise, could you please give a bit more details on the formula field and its inputs?

See Solution in Thread

1 Reply 1

How are you calculating the {Total #of questions}? What field types does the formula pull its data from?

It looks like the {Total #of questions} formula is returning a string value, instead of a number. Notice that it is left aligned, instead of right aligned.

You can wrap the {Total #of questions} field in the VALUE() function to force it into a number. Then the calculations should work.

However, even if that works, you might want to revisit the formula for {Total #of questions} to better understand what is going on.


If this answers your question, please mark this post as the solution. Otherwise, could you please give a bit more details on the formula field and its inputs?