Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

transform minute value in hour

Status
Not open for further replies.

f4b10

Programmer
Jul 4, 2009
3
IT
hi everybody, i'm new to cognos world, and i have some problem with the report studio.After create and deploy the correct package , i run report studio and create my report.The problem is that one query item rappresenting the oen value in minute, i want to convert in hour.
ex 7153 minutes = 119.3 on this value i'm sure because on excel i do this 7153*60/3600/24 and return the correct value.
How i can do it with report studio, on the query item i have try to do the same , but with very bad result.
Can someone help me please?
 
What did you create and what goes wrong?

Ties Blom

 
Hi blom0344, i have create a package with framework manager, the data item contain a value that is the number of minutes, ex 60 120 240 minutes corresponding 1 hour,two hour and so one, but i want format it correctly because i want see the number in hour and for the moment i cannot modify the package.
So i think that is possible converting this number of minutes in the corresponding hour.
i have do in this way
[foundationboject view].[myqueryitem].[dataitem] *60/3600/24 but with very bad result because is not the correct value.
Can you help me in some way to understand what is the right conversion to obtain the right value?
thx
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top