AnsweredAssumed Answered

Advanced Reporting: How to show total resource demand regardless of employment type

Question asked by schaak01 on Sep 26, 2017

Hi,

 

I would like to show the total resource demand regardless of employment type against the capacity of employees only. Essentially, I would like to show that the demand exceeds the amount of employees we have, thus requiring us to hire contractors. 

 

Example: A department has the capacity of 30 Employees and 15 Contractors with a total demand of 45 FTEs. I need a report to show the total demand of 45 FTEs with the capacity of the 30 Employees.  (I have attached a Word document with screenshots of what I am describing).

 

The Capacity vs Allocation by OBS report allows me to run only employees, only contractors, or both, however, when I select only employees, the report shows the demand of employees only rather than total demand. 

 

Is there any way to show this either in an OOTB report or by creating a custom report? Or does one of the OOTB portlets show this? 

Outcomes