Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Scheduling Rooms - Count multiplied by Occupancy = Total workaround

3 ANTWORTEN 3
GELÖST
Antworten
Nachricht 1 von 4
mlvau
701 Aufrufe, 3 Antworten

Scheduling Rooms - Count multiplied by Occupancy = Total workaround

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 :leicht_lächelndes_Gesicht:

room count-occupancy.png

Beschriftungen (4)
3 ANTWORTEN 3
Nachricht 2 von 4
ToanDN
als Antwort auf: mlvau

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.

Nachricht 3 von 4
mlvau
als Antwort auf: ToanDN

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

formatting tab.png

Nachricht 4 von 4
pmdewi
als Antwort auf: mlvau

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.

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report