Forum Discussion

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
4 years ago

HC Join and left

Hey All! Thanks to whoever helped so far, But I have not yet reached a solution even though I have come very close Publishes the problem here again something is wrong I do not know to point...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
4 years ago

Hi netanel ,

 

Believe that the issue whit this calculations is regarding the dates of hire and of termination.

 

One of the measure believe that you need just to add a filter for the termination blank you get 4236 not 4235 but it close:

 

Regarding the other measures I assume you need to have some count based on Hire date and termination, but not sure about the data can you please return some more insights

 

  • netanel's avatar
    netanel
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Hey MFelix 

    Great to see you again

     

    Thanks for the reply!
    I'm really happy for help
    Regarding HC who are currently working I have solved the problem
    I have attached two formulas that explain my logic both of them work great.

     

    For employees who entered and employees who left
    I tried to rely on a Hire column and a Termination date column and I can not reach the correct number


    Each month comes a file of the employees currently in the organization
    And the calculation is like this
    An employee who was in the previous file and now he is not found so he left
    An employee who was not in the previous file and is now found is new

    base on person Number Column

     

    Thanks!

    Link to file:

    https://1drv.ms/f/s!AonyYI-TdspHgUhwngZ6OKvpnSsc

  • netanel's avatar
    netanel
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Hey, MFelix 

    do you think you can help?