SUM Duration V5.1

rocketman

Just tryng to use the grouping facilities in a query, which is working fantastic with SUMming numbers. However it doesn't appear to be working with attributes of type Duration. When I set it to SUM an duration attibute, all I get are the letters "HH:MM"

Am I supposed to do something with the {values} setting? - I can't find this bit documented anywhere.

I'm also having the same problem in a group band, I can't SUM a Duration attribute in the group band footer

rocketman

Bump

rocketman

Any update on this as I can't even do a simple summation of a time sheet report

Works when I put some html code in the summary section of a query. For example THIS WORKS
Launches Mnth: <<SUM Gliders.LaunchesThisMonth>>. Hrs month: <<SUM Gliders.HoursThisMonth>> . Launches Yr: <<SUM Gliders.LaunchesThisYear>>. Hrs Yr: <<SUM Gliders.HoursThisYear>> . Airtime Fees Yr: £<<SUM Gliders.Airtime_Fees_This_Year>>

WON'T work when I put a SUM field in either a group footer or page footer on a report

For example: I have a group band called employees. The detail line contains, Employee ID, shift start time, shift end time and shift duration.

I have a calculated field the the band footer "SUM Shift Duration"

If I set the evaluation details in properties to "When the expression is encountered I can get something to print. Unfortunately its a rolling total of all the previous employees shift durations - not what I want.

If I set the evaluation details to "At the end of the group" - Nothing prints

To reiterate - this only applies to duration fields. Numbers are fine

rocketman

AwareIM Support - has this been fixed yet? Can't see it in the changelogs.

Cannot SUM durations in Group bands on reports or on-screen queries. All you get is the characters HH:MM instead of the actual duration