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
SUM duration in a group section of a query
SUM duration in a group section of a query
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 a group section of a query
you're in luck.
looks like this was solved here: <G>
looks like this was solved here: <G>
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
Jaymer
Aware Programming & Consulting - Tampa FL
Re: SUM duration in a group section of a query
@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?
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
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
Re: SUM duration in a group section of a query
Winding you up ? who, me ?
Sounds like Vlad's the one who's been winding you up !
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
Jaymer
Aware Programming & Consulting - Tampa FL
Re: SUM duration in a group section of a query
Rocketman
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5