Calculate number of minutes in YTD

[#1]

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

[#2]

Hi Mat,

You are right , this is straight forward.

Thanks so much.

Regards

Louwrie