Just can't understand a basic percentage operation

Dimi_Timeline · ‎May 25, 2020

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?

kuovonne · ‎May 25, 2020

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

kuovonne · ‎May 25, 2020

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?