SUM duration in a group section of a query

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
rocketman
Posts: 1252
Joined: Fri Jan 02, 2009 11:22 pm
Location: Preston UK
Contact:

SUM duration in a group section of a query

Post by rocketman »

This is a long standing issue dating back to 2011, So I hope i've missed something along the way. Does anyone know how to SUM a duration attribute of a group in a query or presentation? please please please.

https://1drv.ms/i/s!AmlhuKdaEBz0jaxwJ8x ... g?e=YSrDI8
Rocketman

V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
Jaymer
Posts: 2475
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: SUM duration in a group section of a query

Post by Jaymer »

you're in luck.
looks like this was solved here: <G>
Screenshot 2024-04-18 at 9.49.58 AM.png
Screenshot 2024-04-18 at 9.49.58 AM.png (109.27 KiB) Viewed 6801 times
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
rocketman
Posts: 1252
Joined: Fri Jan 02, 2009 11:22 pm
Location: Preston UK
Contact:

Re: SUM duration in a group section of a query

Post by rocketman »

@Jaymer .... you're winding me up rights? This build number (1539) is from V5. I am on 8.7 .... soon to be 9

It might USE the duration attribute but it sure as hell doesn't SUM them correctly in the group summary. Did you check the image link I put in the post?
Rocketman

V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
Jaymer
Posts: 2475
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: SUM duration in a group section of a query

Post by Jaymer »

Winding you up ? who, me ? :lol:

Sounds like Vlad's the one who's been winding you up !
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
rocketman
Posts: 1252
Joined: Fri Jan 02, 2009 11:22 pm
Location: Preston UK
Contact:

Re: SUM duration in a group section of a query

Post by rocketman »

Jaymer wrote: Thu Apr 18, 2024 3:42 pm Winding you up ? who, me ? :lol:

Sounds like Vlad's the one who's been winding you up !
:roll:
Rocketman

V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
Post Reply