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

Problem in Division operation

Started by everlearner, 04 Jun 2012 02:47:55 AM

Previous topic - Next topic

everlearner

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


blom0344

What is the data type of the duration? Did you format the column as a number?