TD-23276: Totals and subtotals for grouped timecolumns

[Uwe van der Horst]

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.

[Uwe van der Horst]

The new feature is targeted to be available in TD7.1

[Riuks]

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]

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