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
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi tobiasmcbride 

 

Another way would be selecting a date point in the future by replacing start date nulls with let's say today + 30 and allocating this individual there.

 

 

Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn

 

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

Hi Mariusz 

 

trying to get this to work looking forward in time and seems to only be working from today backwards. We have some confirmed starters in the data that we can look forward and, hence, compare with budget. still trying to work out how to deal with the data quality matter around null start dates to get most accurate position so if any further ideas on this would be great.