nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

GrandTotal using time column

crrocha

Hi all,
 
It is possible to create a sum of a time column? For instance, I have a dataset with 3 columns (id, name and time) and I want to create a grand total of time in one table.
 
Thanks.
 
PS.: I'm using BIRT 2.5

Find more posts tagged with

Comments

micajblock

Please define how one would aggregate time? How is it stored in the DB?

crrocha

I'm using SQL Server and I tried to create a sum of this query (It's just a example to simplify the question):
<pre class="_prettyXprint _lang-sql">
SELECT 1 AS [Id], 'name 1' AS [Name], CAST('01:00' AS TIME) AS [TesteTime]
UNION
SELECT 2 AS [Id], 'name 2' AS [Name], CAST('02:00' AS TIME) AS [TesteTime]
UNION
SELECT 3 AS [Id], 'name 3' AS [Name], CAST('03:00' AS TIME) AS [TesteTime]
</pre>
<div>
 
</div>
And I want this output of report:
<pre class="_prettyXprint _lang-">
Id Name TesteTime
1 name 1 01:00:00
2 name 2 02:00:00
3 name 3 03:00:00
Total 06:00:00 <~ sum all of the times
</pre>

micajblock

Is the original field a date time and you are just displaying the time?

crrocha

Yes, the original field is date time and I just want to display the time and grand total of this time.

micajblock

You will need to use the BirtDateTime functions to calculate this. I think these functions were available in 2.5.