Forum Discussion
Helper IIINumber at a particular date
Community Champion
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.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Helper IIIThanks Mariusz managed to get it working eventually looking backwards from now.
I have budget headcount data too like so:
| Budget | Date | Headcount Value |
| Latest Plan | 31 October 2017 | 1101 |
| Latest Plan | 30 November 2017 | 1106 |
I want to display the chart with headcount data for the actuals and the budget line for 'latest plan'. However it seems to when displaying on the chart take the sum of all of these values for a particular time period so I get tens of thousands for the budgeted headcount and that remains fairly constant over time whilst the actual headcount data flucuates as you modelled.
I think it has to do with the fact that the budget 'date' is only the end of the month or something but wondered if you could assist?