BusinessObjects Board

Can i format seconds to dd:hh:mm:ss format

building semantic layer
#1

Hi All,

I have a dimension which returns data in seconds.
But I need to display in dd:hh:mm:ss format and the data type should be Date or Time. Does this formating is possible in Webi?

If yes… please guide me

rbogireddy :india: (BOB member since 2011-06-13)

Converting seconds to dd:hh:mm:ss format
#2

Hi,

Yes, it’s possible to display number of seconds in the required format. However, the data type will be string and not the date or time.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#3

use ToNumber to convert to number and then convert seconds to the desired format using floo and mod. This thread should provide sufficient guidance:
https://bobj-board.org/t/113742

On a more general note, try and use the forum search prior to posting a new question :wink:

BUDJO :switzerland: (BOB member since 2013-01-10)

#4

Thanks Marek…

I didnt see my previous post in the list. Because of that reason i sent a new post. Anyways thanks for the reply. I wont repeat the cross posting…

rbogireddy :india: (BOB member since 2011-06-13)