In one of the DWH report(project status report), there is a change requested to convert actual hours to days.
I am looking for a formula for each resource , number of Actual Days=total Actual hours/daily resource availability, but in dwh schema.
dwh_cmn_periods table has data for MONTHLY , WEEKLY etc but not for DAILY.
Highly appreciate any inputs or suggestions how to achieve this.
Clarity version:15.3 ;Jasper:6.4.2