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

Formatting Seconds to HH MM SS

Started by tipro1986, 30 Jan 2014 02:35:54 PM

Previous topic - Next topic

tipro1986

I have a cube created from a Report Studio report as the source, and in the report, there is a field that is a calculation of the time between two dates.  When running the raw report, the difference shows up as an interval (i.e., "2 hours 22 minutes 35 seconds").  So far so good.

In Transformer, I have a Measure created which is just a basic Sum of the interval field.  The issue is that Sum Measure is showing up as just a total of seconds (i.e., "6001" ).  What I would like to show, is some form similar to what the Raw Report is showing ("1 hour 40 minutes 1 second").

I have tried looking for where to do this all over, both within Analysis Studio, as well as in Transformer.  I can't seem to figure this one out. 
TIA for any kind of help.
--TI