Submitted by David_H on 2016/08/10 19:34
I have a start time and end time column which in turn populate a duration column.  I'd like to create an additional column for "total hours" that sums the duration column for the DAY.  To be clear, I do not need this to be project specific.  It's not for billing or anything like that and doesn't need to roll up to a parent item.  I just want to be able to look at my Done grid, and see a total hours column that shows how much time I logged for the day.
 
Can anyone (maybe Pierre ) give me the exact syntax I need to enter, and on which field/s, to accomplish this?
 
Thanks!

Comments

Check out Field Management Dialog - Equations , second screenshot, and the Hierarchy Equations (Column Equations) section (there you'll also find explanations on Hierarchy Equations with Parameters).
 
Basically, if your duration's total calculation doesn't rely on any specific condition you just need to:
 
- select "parents" in the column equation part of the equation section (field properties)
- write SUM after the "=" sign.
- you might want to check  the "auto-update" option right above (if you don't you'll have to right-click on the field at the parent level and perform a recalc : Edit>Re-Calculate (shift-F9)
 
 
-
IQ geek
Windows 8.1
CPU: Intel i5 2.6ghz

Thanks Armando.  However the challenge is I am not trying to sum either parents or children.  I simply want to sum ALL *durations* in the entire database for that DAY, and I'm unsure how to do that.  I've attached a screenshot of what I'm trying to achieve.

Pierre_Admin

2016/08/22 15:30

Permalink

You could use a pivot table to sum by day
 
Pierre_Admin
IQ Designer
 

Thanks.  When I open a pivot table in my database, and attempt to add fields, I experience what you see in the attachment - the pivot table field list is empty.  What criteria defines whether a field shows up there?
 
When I open the sample database, I do see a limited set of fields there, but even then some show up and some don't, for instance start date shows up, but not end date.

Pierre_Admin

2016/08/22 16:16

Permalink

Right-click on a blank area and select Reset configuration
 
Pierre_Admin
IQ Designer
 

Thanks, I have it working in a basic fashion, this gives me something to play with.  Any way to hyperlink to a pivot table for a specific grid ?