Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Turnover Report Calculation/Field

Accepted answer
81
Views
5
Comments

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 Termiation Headcount, Involuntary Termination Headcount, Calendar Year.

Best Answer

Answers

  • EzequielC-Oracle
    EzequielC-Oracle Rank 6 - Analytics Lead

    This is the Oracle Analytics Cloud / Oracle Analytics Server Community.

    Your question looks more related to Oracle Payroll or Oracle HCM.

    Can you provide more details on what product you using and if possible an example of what you want to achieve?

  • MMS
    MMS Rank 2 - Community Beginner

    Hi Ezequiel - No, it is not payroll related. It is to determine the calculation for turnovers on the property side. The current report does not include LOA TMs as active. So, they are removed from the calculation - when they should still be included. We looking for a field/ or formula to include them in the count.

    We were referred to enter our question in the Cloud Community by Oracle support.

  • What is the name of the product you are using?

    You asked in the OAC/OAS category, but OAC and OAS are platform without any content, while your question is about some type of pre-packaged content (or your own custom data models).

    Based on your reply, your question can be moved to the right category or you can be pointed to the right place where to ask.

  • MMS
    MMS Rank 2 - Community Beginner

    Hi Gianni- We are using TMX (Oracle HCM) Version 22D. Thank you.