Hi,

I need to have a hospital daily bed occupation with a % calculation from the total beds available (goal).

In the database I have the "date in" for each patient and the "date out" (it could be blank if still is hospitalized).

I need to represent that a bed is occupied every day in the range from "date in" to "date out" (today if blank).

Any suggestions in how to do it?

TIA

Pepe