Using current position in the year to make a calculation

[#1]

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,

[swuehl]

Are you looking for something like

=month(today() ) / 12 * 120

[#3]

Is there anyway to do it using financial year?

[swuehl · Accepted solution]

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).

[#5]

Thanks thats works perfectly.