Occupancy Report

  • 17 January 2023
  • 0 replies

I am very much a newbie but wanting to create an occupancy report from a master rent roll (data source) of rental units.  The units are within 11 different properties and held by 2 different parent companies.  At any given time we want to see the occupancy overall, by each parent company, then also property.  I built a report that shows a chart of total square feet by property and then a separate table of just vacant units by property.  Occupancy rate = Total Sq. ft.- Vacant Sq. ft./ total sq. ft.   I would also like a property that contains a vacancy to be a different color - that might be more difficult.

Here is my current report.  Any help is much appreciated.


0 replies

Be the first to reply!