Solved TD-23276: Totals and subtotals for grouped timecolumns

Missing or incomplete OpenText Gupta product features? Discuss it here!
Uwe van der Horst
Site Admin
Site Admin
Germany
Posts: 62
Joined: 05 Mar 2017, 14:21
Location: Wetter (Ruhr), Germany

TD-23276: Totals and subtotals for grouped timecolumns

Post by Uwe van der Horst » 05 Mar 2017, 19:06

TD 6.3 supports subtotals for grouped columns of Grid Tables, e.g. in Attribute Inspector by setting "Summary Bar Enabled" to "Yes + Groups". There is a limitation: This works only for numbers, not for time (duration) = date/time columns (e.g. with format "hh:mm" or "hh:mm:ss").

Setting "Column Aggregate Type = User Value" does not help. With this setting you can display the total in summary bar (doing string conversations), but after grouping the subtotals are missing.

After discussing with Martin Teetz at DevCon 2016 I have created an enhancement request.
Best regards,
Uwe van der Horst
Advo-web GmbH

Uwe van der Horst
Site Admin
Site Admin
Germany
Posts: 62
Joined: 05 Mar 2017, 14:21
Location: Wetter (Ruhr), Germany

Re: TD-23276: Totals and subtotals for grouped timecolumns

Post by Uwe van der Horst » 11 May 2017, 09:17

The new feature is targeted to be available in TD7.1 :P
Best regards,
Uwe van der Horst
Advo-web GmbH

Riuks
Estonia
Posts: 5
Joined: 10 Mar 2017, 07:41
Location: Tallinn, Estonia

Re: TD-23276: Totals and subtotals for grouped timecolumns

Post by Riuks » 07 Nov 2017, 21:35

Hi.

I notice here with subtotals another issue/upgrade request: if group is collapsed it would be nice to see group subtotal value anyway, right now if all groups are collapsed only column total is visible ...

RIho

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 484
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: TD-23276: Totals and subtotals for grouped timecolumns

Post by Dave Rabelink » 30 May 2018, 14:30

This enhancement is added in TD 7.1.

Quote from New and Changed features TD 7.1
A new SAM message SAM_DateColumnSum is supported on grid columns.
This allows for custom date totals.
Use with new functions SalGridColumnSummaryDateValues and SalDateReturn
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Return to “Enhancement suggestions”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests