Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to handle time calculations in OBIEE ?
ClintonR
Rank 1 - Community Starter
Hello,
I have below case to be handled in OBIEE, could anyone please help me calculating total hours.
Regards,
Clinton
0
Answers
-
Hi,
sorry but ... what is wrong with your totals? 42.88 - 36 = 6.88, and the totals are the sum of the values of your columns, so it's fine ...
If you ask OBIEE to display your 42.88 as 42 hours and 53 minutes you are asking too much as in your example your data is normal numbers.
0 -
Divided by 100 then multiplied by 60 gives you the decimal places in minutes.
0
