Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Turnover Report Calculation/Field

Accepted answer
84
Views
5
Comments
MMS
MMS Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

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.

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.