Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Worker Age in Workforce Trends
Summary
What to use to calculate age in Workforce TrendsContent
Hello!
I've been calculating the Age Bands by using a formula to gather the difference between the date of birth and a specific date for reporting. I end up using a different date depending on the context.
- For Workforce Overview - Assignment Real Time: We're using the current_Date because it's reporting on current assignment information
- For Workforce Overview - Assignment Event Real Time: We're using the Date from the Time Dimension because the relevant age for analysis is what age the worker was when the event happened
When I tried to use "Time"."Date" in Workforce Overview - Workforce Trend Real Time it doesn't come back with any results. I suspect this is caused by the report aggregate function grouping on the other attributes of the time dimension. (Year, Quarter, Month)
0