# Just can't understand a basic percentage operation

Topic Labels: Formulas
Solved
740 1
cancel
Showing results for
Did you mean:  5 - Automation Enthusiast 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  18 - Pluto

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?  18 - Pluto

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? 