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)
This is the table where the rollup SUM(Values) occur
Rollup SUM(Values) is producing NaN
+35That is odd. In your first table that you posted, what are your exact formulas for those 3 formula fields?
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}
+35Strange 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”?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.