+4
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?
Best answer by kuovonne
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?
+29How 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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
