I’m trying to sum values in a rollup function an am getting an #Error value returned.
Here’s how it’s structured. In one table I have “Start” and “End.” These are date and time fields. I have a separate column in the same table that is a formula called “Hours” Basically, it calculates the time and turns it into a decimal like “1.1” hours. It is a way to log activities for a specific project. So most projects will have multiple entries per project with various time entries.
In a separate table, I’m trying to use a rollup sum(values) function to calculate all the hours for specific projects. I’ve been able to accomplish this with all expenses related to projects, but not with the time. For some projects it displays a number or 0.0 but for others it displays “#ERROR!”