Help

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

Rollup SUM(Values) is producing NaN

423 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I have checked the table field for the rollup. All cells contain a number. Any idea what went wrong?!

This is the table field that is used to rollup SUM(Values)

Screen Shot 2021-01-18 at 10.14.53 PM

This is the table where the rollup SUM(Values) occur

Screen Shot 2021-01-18 at 10.14.28 PM

3 Replies 3

That is odd. In your first table that you posted, what are your exact formulas for those 3 formula fields?

Strange right? It computes all the other rollups just fine except for this one record.

Here are the formulas:

Hours Worked: (DATETIME_DIFF({Paid Time-out},{Paid Time-in},‘minutes’)/60)-{Break (in hours)}
Total R Hours: {Hours Worked}-{Total OT Hours}
Earnings: {Total Regular Pay}+{Total OT Pay}

Yes, very strange that it’s only affecting that one record. I don’t know if I have any answers for you! You might need to email support@airtable.com and ask them to look at your base.

In the meantime, I’m assuming that “Paid Time-out“ and “Paid Time-in” are Date/Time fields. What types of fields are “Break (in hours)”, “Hours Worked”, “Total OT Hours”, “Total Regular Pay”, and “Total OT Pay”?