HI
I am having a OLAP cube and a standard measure which needs to be in hh:mm format. currently the number is coming in float. Guidance much appreciated.
Best answer by Thomas Lind
View original
Userlevel 6
+5
Hi Jyothi
Just so everybody who reads this question knows it is possible to solve.
The solution to this is, you set up the format as hh:mm:ss. You cant find it in the list, but manually typing it in will work.
Before you us this, you need to divide your measure with a fraction of a day. So Seconds is 86400 (60*60*24), minutes is 1440 (60*24) and hours is 24.
Hi Thomas,
It worked as expected. I'm glad that you gave me a solution.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
