AnsweredAssumed Answered

Convert resource actual hours in days jasper(DWH)

Question asked by shammytaj on Mar 19, 2018
Latest reply on Mar 29, 2018 by shammytaj

Hi  ,

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