- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.7K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.5K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
how to sum the h:mm values in obiee report
I want to sum the hour minute values based on time based analysis.
for example , i have spent 1hr 55min on project1 work & 1hr 45min on project2 work then total hours should be 3hr 40min . pls see the below screen shot.
here No.of hours assigned column data coming from fact.hour_assigned_actual column . data type is number.
in obiee report level data like 1.55, 1.45, 3:13,3:20,0:59,404:13..(data is not extracted from date column. it is fact data ).
But in obiee report sum of hours showing as 3hrs. I think it taking as actual sum. It is nt summing the time based.
total hours showing wrong in obiee report .pls see the below screen shot
I have tried in obiee report but i couldnt resolve this issue. please help me .
please share ideas.
Thanks in advance,