Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

# Nan Error To Calculate Percentage

Topic Labels: Formulas
Solved
903 1
cancel
Showing results for
Did you mean:  4 - Data Explorer

Hi All,

I am very new to airtable and trying to decide if this tool is right for our team. I think that it is, I am just having an issue trying to calculate the percentage.

I have a count of subtasks as well as a count of the completed subtasks (linked record to another table,‘subtasks’). I wanted to use these two fields to calculate the percentage of completion. I added a new field and called it percentage complete and used the below formula: {Number of Completed Subtasks}/Number of subtasks and formatted as percentage.

Since some items do not have any subtasks at all (0) I am getting the NaN error for percentage. How can I rectify this so that the NaN error, essentially 0/0 returns an actual percentage to help me with the bigger picture?

I have added a screenshot for reference: any help is appreciated, thanks!

1 Solution

Accepted Solutions  10 - Mercury

Hi there! You’ll want to use an IF() statement to first check if there is a value in {Number of Subtasks} before using it as a divisor. Try this…

``````IF({Number of SubTasks}, {Number of Completed Subtasks} / {Number of SubTasks}, 0)
``````

This should return the percent complete if there are subtasks, otherwise it should return 0%.

Hope this helps!  10 - Mercury

Hi there! You’ll want to use an IF() statement to first check if there is a value in {Number of Subtasks} before using it as a divisor. Try this…

``````IF({Number of SubTasks}, {Number of Completed Subtasks} / {Number of SubTasks}, 0)
``````

This should return the percent complete if there are subtasks, otherwise it should return 0%.

Hope this helps! 