Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Add 2 Report Measures: Dept Active FTE and Vacancy Rate % — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Add 2 Report Measures: Dept Active FTE and Vacancy Rate %

Accepted answer
11
Views
5
Comments
edited Nov 27, 2022 6:57PM in Reporting and Analytics for HCM 5 comments

Summary:

I have an Analysis that calculates vacancy rate by department. I need expert advice on how to add two measures to the pivot table. I want to add a measure "Dept Active FTE" (this is the total number of active FTE's in the dept) and add a calculated Vacancy Rate % measure. This calculation is: Open Work FTE / (Open Work FTE + Dept Active FTE) * 100.

I hope this is possible and thank you in advance for your assistance.

The catalog file is attached. The Excel output should look like this:


Content (required):


Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!