Hi, I have posted a previous post on how do i calculate the days in YTD and im still stuck but also now i need to know the minutes in YTD in order to calculate the percentage theatre utilisation in a hospital. i have a field to caculate the actual minutes used in a theatre and my set analysis on this are. TheatreTotaltime is the actual minutes that the theatres were used. this i must used to calculate the percentage utilisation of the theatres
=
Sum({$<Year={"$(=Year(Today()))"},Month={">=01 <=$(=Num(Month(Today()))-1)"}>} TheatreTotalTime)
Now i need the actual minutes for YTD to calculate the percentage usage of the theatres.
Would really appreciate help how to calculate this percentage.
Regards
Louw
