Hi,
I am modelling Trauma Theatre demand and capacity with a set of resources. I want to calculate utilisation. Currently I am using the below expression:
'[Theatre1].UnitsInUseAverage / [Theatre1].Capacity'
However, this calculation continues even when the threshold is closed, so my utilisation is always low. I need a way to calculate the utilisation of a resource only when the threshold is open.
Any insights or suggestions would be greatly appreciated.
Note: I have been able to do this using a server, but require resource to manage priorities between urgent trauma and non-urgent trauma.
Thanks,
Piers