I have a theatres dashboard for the hospital. I have one box showing the planned sessions for the year, a box showing the expected sessions to date, which just uses todays date and works it out (=round((today() - YearStart(today(),0,4) ) / 365 * sum(Planned_Sessions))), then i have an actual sessions performed which is a count of sessions. This all works fine until you select a different year in the selection boxes.
I need to show financial years from 2010/11. The problem is- each time you select a different year it still works the expected out using the count from today. I would like the previous financial years to show the expected number at the end of the year, so 31st march, but when the current financial year is selected it still works it out how it is doing now.
So its basically, once the financial year has ended, the expected sessions box should stay the same and the formula only work when you select the current financial year
Hope this makes sense?