Forum Discussion

tobiasmcbride's avatar
tobiasmcbride
Icon for Helper III rankHelper III
6 years ago

Number at a particular date

Hi,   I have the following data on headcount.   Name Position Start Date End Date Current Status Joe Bloggsd Head of Marketing 21/02/2017   Established Noah Anyone Head of Opera...
Need Help
tobiasmcbride's avatar
tobiasmcbride
Icon for Helper III rankHelper III
6 years ago

Hi Mariusz ,

 

Looking at data again these are budgeted leavers (i.e. those we budget to leave this coming FY) this is what we have in the database with no start date but a particulary end date given our attrition modelling. What would you suggest to do as would actually like to keep these budgeted leavers in there but work out a way to tweak the formula to take account of null dates?

 

 

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi tobiasmcbride 

 

What would be their start date as an assumption? 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn