Nan Error To Calculate Percentage

[Sarah_Morris]

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!

[AlliAlosa · Accepted solution]

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!