If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Hour Values > 24

Started by MiP, 27 Mar 2012 04:29:30 AM

Previous topic - Next topic

MiP

Hi,

I need to sum up a column which holds hour values. The single values are always < 24 hours and are formated as time interval with the time unit 'Time'.
Summing up those values should e.g give a value of 28:00, but it is shown as 1 04:00.

Maybe it is really a question that is easy to answer but I can't find any way to display hours > 24:00 in the same format.

Thanks very much for every hint!

Mike

blom0344

Time interval may not the best choice as Cognos will add days to the formatted data when more than 24 hours are used.

Why not sum them as integers and then use cast the total to a varchar and adding  the :00 part to the string?

MiP

Thanks for your reply.
Thought that there would be a different way to solve this.

Thanks very much!