Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to handle time calculations in OBIEE ?

Received Response
2
Views
2
Comments
ClintonR
ClintonR Rank 1 - Community Starter
edited Aug 13, 2024 7:08PM in Oracle Analytics Cloud and Server

Hello,

I have below case to be handled in OBIEE, could anyone please help me calculating total hours.

Time.PNG

Regards,
Clinton

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Divided by 100 then multiplied by 60 gives you the decimal places in minutes.