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 ![]()
Gelöst! Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
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.
In formatting for Occupancy the calculation field is greyed out so it's stuck in "no calculation"
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.