Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Turnover Report Calculation/Field
MMS
Rank 2 - Community Beginner
I need help to identify a measure or a field calculation that uses both Active and LOA assignment statuses for period headcount.
The columns being used are: Team Member ID, Voluntary Termination Headcount, Involuntary Termination Headcount, Calendar Year.
0
Answers
-
Hi @Mykol Sutton which subject area are you using for this? You can actually use the headcount column and filter it by respective assignment status type along with the month column, it will give you end of the mpnth headcount value. for ex: Filter(Headcount USING Assignment Status Type IN (Active, LOA))
Raghu
0 -
@Raghavendra Raghunath-Oracle Hi! The subject area is Workforce Management -Workforce Trend Real Time.
0
