Skip to main content
Question

Pro Training: Workforce Planning EE_Load_HRIS Date configuration

  • October 8, 2024
  • 4 replies
  • 226 views

Forum|alt.badge.img+2

The hire date for EE00001 is 10/01/2022, but when I apply the formula, it shows as January 2023. Am I missing something?

EE_Load_HRIS: 



 

 

4 replies

sethbradley
Master Trendsetter
Forum|alt.badge.img+8
  • Master Trendsetter
  • October 8, 2024

Looks like the formula is working, Is your load month Jan 23?


Forum|alt.badge.img+2
  • Author
  • Apprentice Author
  • October 8, 2024

The load month for employee ID E000001 is 12/31/2022, and the hire date is 10/01/2022, but both are showing as January 2023 in the EE_Data_Load Month and EE_Data_Hire Date metrics.


Forum|alt.badge.img+2
  • Author
  • Apprentice Author
  • October 8, 2024

I opened the dependency diagram and noticed that my set actuals have been marked as "true" starting from January 2023. Is this something I need to update?
 

 


sethbradley
Master Trendsetter
Forum|alt.badge.img+8
  • Master Trendsetter
  • October 8, 2024

Yeah this is filtering the data you report on to a month later that that of the load month of your transaction list. Which may be intentional if  the only data you care to show is Jan 23 and forward. Looks like your are using the Version to determine which reporting months that are relevant. 

If you should be reporting from Dec 22 onward you would do:

(Month.‘Start Date’ >= EE_Load_HRIS.‘Load Month’.‘Start Date’)[CURRENTVALUE = TRUE]