Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
Many Thanks,
Probably yes.
Maybe like
=round((today() - YearStart(today(),0,4) ) / 365 * 120)
where the third argument to yearstart() defines your financial year start (here: April).
Are you looking for something like
=month(today() ) / 12 * 120
Is there anyway to do it using financial year?
Probably yes.
Maybe like
=round((today() - YearStart(today(),0,4) ) / 365 * 120)
where the third argument to yearstart() defines your financial year start (here: April).
Thanks thats works perfectly.