COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: everlearner on 04 Jun 2012 02:47:55 AM

Title: Problem in Division operation
Post by: everlearner on 04 Jun 2012 02:47:55 AM
hi Gurus,

I have a column name Duration, That contains value in the form of Minutes,

What am trying to do is, I wanted  to display duration in Hrs. For that i have applied the division on Duration column like as below.
Duration/60( not sure whether it is right or not)

it is  in minutes only after running the report, but at the bottom of the column am getting total in Hrs.

Can any one please let me know how to perform this, how can i display duration in hrs. i dont need the sum at bottom.

Thanks in advance

Title: Re: Problem in Division operation
Post by: blom0344 on 04 Jun 2012 03:38:36 AM
What is the data type of the duration? Did you format the column as a number?