Ok I'm re-posting this in this section because there has been no response from my post in "Problem Reports"
Trying to SUM or AVG a duration attribute using the "Group" button in Query details does not seem to work. All I get are the letters HH:MM.
the same applies to group bands within reports.
Support - can you confirm this is a bug and a likely fix time.
Putting <<SUM Flight.duration>> in the summary section works fine - bu tof course, that only gives me the numbers for the whole report
SUM Duration in the group sections
SUM Duration in the group sections
Rocketman
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: SUM Duration in the group sections
Hi Support,
Did this ever get fixed?
Did this ever get fixed?
From,
Himanshu Jain
AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
Himanshu Jain
AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
Re: SUM Duration in the group sections
bump!
From,
Himanshu Jain
AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
Himanshu Jain
AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
Re: SUM Duration in the group sections
This still seems to be a problem (March 2023)
Rocketman
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
Re: SUM Duration in the group sections
Bump - It's only been 12 years!!!
Rocketman
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5