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

Convert seconds to HH:MM:SS

Started by Snavelyone, 14 Sep 2008 08:05:59 PM

Previous topic - Next topic

Snavelyone

I am able to convert my talk time from seconds to HH:MM:SS and publish my IQD. When I bring it in as a measure I get error TR0210 or if I break them up Hours, Minutes, Seconds and try to create a measure by concating them it just shows 0's. Has anyone tried to convert seconds to HH:MM:SS and use it as a measure in Transformer???????

atnaatna

You should just keep the measure as seconds.  When you convert it to HH:MI:SS and try to use it as a measure it does not make sense as Transformer does not know how to roll this value up since "HH:MI:SS" is really a string.