Scheduling Rooms - Count multiplied by Occupancy = Total workaround

[mlvau]

Hello all,

I am trying to use a room schedule to list the rooms in a project and then get the total occupancy of these rooms.

So the schedule has three fields:
Name | Count | Occupancy

The rooms might have the same name but have difference occupancy, for example there is one focus room that has an occupancy of 2 and two focus rooms that have an occupancy of 1.

At the moment under the "Sorting/Grouping" tab I have the schedule sorted by Name first and the Occupancy and "Itemize every instance" is not ticked.

If I remove Occupancy from "Then by" and just leave it "None" then all focus rooms combine and then Occupancy column states <varies>

I tried creating a formula but an error shows up saying "Count" can be used in a formula.
I guessing that I need to create a couple more parameters so that they can be multiplied but can't seem to make it work.

Any help would be really appreciated 🙂

[ToanDN · Accepted solution]

Formatting tab > set Occupancy to Calculate Totals.

Sort by Name only, untick Itemize every instance then the Occupancy column will show the total occupancy of all rooms with the same Name.

[mlvau]

In formatting for Occupancy the calculation field is greyed out so it's stuck in "no calculation"

[pmdewi]

Hi @mlvau , I am having the same problem here.

It turns out the "Occupancy" Built in parameter from revit is an text parameter.

Therefore, we need to create new parameter based on number, so Revit can calculate the total occupancy.