Turnover Report Calculation/Field

MMS

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.

EzequielC-Oracle

Hi Mykol,

This is the OAC/OAS community.

You need to ask your question in the Fusion HCM Analytics community:

https://community.oracle.com/products/oracleanalytics/categories/fusion-hcm-analytics

Regards,

Ezequiel.

EzequielC-Oracle

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

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

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

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