I created a crosstable
Rows contains the projects
columns contains persons.
In the value fields i would like the sum of total spend time
At this the total it is returned like 1.04:00:00 (so 1 day and 4hrs)
however i want it in hours only, in this case 28:00:00
Tried to change it by setting the format on the field, but it doesn't work
any suggestions?
Rows contains the projects
columns contains persons.
In the value fields i would like the sum of total spend time
At this the total it is returned like 1.04:00:00 (so 1 day and 4hrs)
however i want it in hours only, in this case 28:00:00
Tried to change it by setting the format on the field, but it doesn't work
any suggestions?
3 Answers, 1 is accepted
0
Hi Stijn,
Peter
the Telerik team
You can use the following expression to display the TimeSpan data in the required format:
=Fields.TimeSpanField.TotalHours.ToString("N0") + Fields.TimeSpanField.ToString("\:mm\:ss")
Peter
the Telerik team
BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >
0
Olivier
Top achievements
Rank 1
Rank 1
answered on 08 Apr 2014, 02:33 PM
I have the same question in a table.
I have a column to calculate the spend time
and i want to do a sum on a raw group of the spend time and i have this result "2.02:00:00"
I do your suggestion like
=sum (Fields.TimeSpanField.TotalHours.ToString("N0") + Fields.TimeSpanField.ToString("\:mm\:ss"))
But in the result i have all the raw ( 2:00:00 2:00:00 2:00:00) instead of 6:00:00 for example.
I have a column to calculate the spend time
and i want to do a sum on a raw group of the spend time and i have this result "2.02:00:00"
I do your suggestion like
=sum (Fields.TimeSpanField.TotalHours.ToString("N0") + Fields.TimeSpanField.ToString("\:mm\:ss"))
But in the result i have all the raw ( 2:00:00 2:00:00 2:00:00) instead of 6:00:00 for example.
0
Hello Olivier,
You are passing a string to the Sum aggregate function. This will result in a concatenation of the strings, which were passed to the aggregate function. To avoid this, either pass the correct type of data to the aggregate function, or create your own custom aggregate function which will handle the data as you desire.
Regards,
Nasko
Telerik
You are passing a string to the Sum aggregate function. This will result in a concatenation of the strings, which were passed to the aggregate function. To avoid this, either pass the correct type of data to the aggregate function, or create your own custom aggregate function which will handle the data as you desire.
Regards,
Nasko
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.