Using current position in the year to make a calculation
I need to show at the top of my dashboard, Planned Sessions (for the year) and Actual Sessions (for the year). The planned sessions is just a yearly figure for each consultant taken from a spreadsheet and the actual is a count of the session ids that have actually taken place. I need to show depending on the current date in the year what the consultant should have completed so far regarding the plan...
So, it is currently 3 months into the current year, the yearly figure is e.g. 120 so he should have completed 30. Is this possible?