Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Could someone help with this - it works - but i need it to calculate the percentage of MinAnaesthetistStart times that started within 10 minutes of the MinSessionStart but include all those that started before the MinSessionStart?
sum({<OperationOrder={1},MinAnaesthetistStart ={"<>''"}>} {<CancelledOnDay={0}>} if( frac(MinAnaesthetistStart) < (frac(MinSessionStart) + interval#('0:10','h:mm')),1,0))/ count(DISTINCT{<SessionUsed={1}>} SessionID)