Help

Just can't understand a basic percentage operation

Topic Labels: Formulas
Solved
Jump to Solution
887 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Dimi_Timeline
5 - Automation Enthusiast
5 - Automation Enthusiast

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

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
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?