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.
Question
Format standard measure to hh:mm format.
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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
