Calculated Values

[MS_jkimc65]

My office has upgraded Revit consistently every year.  We had some schedules that were pre Revit 2017 which didn't support calculated values in tags, I hope I said that right?  Anyhow, I am currently looking at revamping a Occupant Load Schedule and Room Tag in hopes to get occupant load shown on our plans.  My schedule seems to be working right, however, the Room Tag is where I am experiencing problems.  I have created a Key Schedule to auto-populate info in my Occupant Schedule based on the "Function of Space".  I have added a parameter with a formula to calculate the "# of Occ".  Everything in my schedule seems to be working.  Once I modify my room tag to include the "# of Occ" I get a return of 0 (zero) once it is loaded into project.  I have included my sample file that I am testing this in.  If anyone has any suggestions on what I am doing wrong, I would appreciate a response.  THANKS IN ADVANCED!

[MS_jkimc65]

I forgot to mention this was done in Revit 2018.

[ToanDN]

Your Net Room Area column shows nothing so obviously the formula returns nothing.

[barthbradley]

Something is wacky with "Occ Load Fixed" in your formula "if(Area Per Occupant > 0 SF, (round(Area / Area Per Occupant)), Occ Load Fixed)". It not pulling"Occ Load Fixed" information from  in your Project's Rooms. I suspect the Tag and the Room are referencing 2 different Shared Parameters with the same name.  I got it to work with one of my SPs just fine.  

...Oh, I also had to add my own SP to the Tag and the Project Rooms for "Area Per Occupant".  Yeah, I think the Shared Parameters you have in the Tag and Project don't share the same GUIDs.   It's working for me when I add my SPs.  

[MS_jkimc65]

ToanDN,
There were two schedules in this sample project, the correct one is the MS - Occupant Schedule which returns the correct "# of Occ" within the schedule, the issue is in the room tag. In this case I saw a video that indicated to either create a parameter or use a shared parameter which is supposed to be "# of Occ" and the formula is to be the same as I set in the schedule itself. I have included the video link below.
https://www.youtube.com/watch?v=P253SSMT2wE


kim candelario,
sr. associate + sr. bim manager

method studio10
360 west aspen avenue | salt lake city, ut 84101
801.718.1527 m
801.532.4422 o

www.method-studio.com

celebrating ten years of excellence
winner best of state | utah 2018
[http://method-studio.com/wp-content/uploads/2018/05/BestOfState_40x40.jpg]

[barthbradley]

You didn't figure it out yet? I tested and provided analysis is post 4/5.  I got it to work. You could not?