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: 

Uncooperative Calculated Values in Furniture Schedule

16 ANTWORTEN 16
GELÖST
Antworten
Nachricht 1 von 17
Sahay_R
900 Aufrufe, 16 Antworten

Uncooperative Calculated Values in Furniture Schedule

What's wrong with this schedule? 

This is what I need to see - with Itemize Each Instance unchecked

Capture.PNG

The highlighted fields are formula driven - 

Capture.PNG

Both Total Existing and Total Proposed are Shared Number Parameters. 

I understand that this is a problem, that prevents the formula from working - 

Capture.PNG

Is there any way around this? I don't want to ask my team to calculate and manually enter values!

 

Thank you in advance....


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
16 ANTWORTEN 16
Nachricht 2 von 17
barthbradley
als Antwort auf: Sahay_R

Hiya Rina.

 

Can you post it? 

Nachricht 3 von 17
ToanDN
als Antwort auf: Sahay_R

You need to enter 0 for all blank cells of Existing Seats, Existing BF, New Seats, New BF.

Nachricht 4 von 17
Sahay_R
als Antwort auf: ToanDN

Here's the deal, @ToanDN  - can't add the 0s. The Proposed Seats and Proposed BFs have a Shared Parameter with a value of 1 so that they schedule by that parameter and give actual counts. The Existing is an invisible 'dummy' family that has a Shared Parameter for the sole purpose of entering the numbers since we do not want to model the existing seating. 

Per @barthbradley 's wish - here is a link to the file - 

https://autode.sk/38lRQKC


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 5 von 17
ToanDN
als Antwort auf: Sahay_R

Who says you can't?  

 

Annotation 2019-12-09 085606.png

Nachricht 6 von 17
Sahay_R
als Antwort auf: ToanDN

OK - you added the parameters to the project - that was the step that I was missing....THANK YOU!


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 7 von 17
ToanDN
als Antwort auf: Sahay_R

I just edit the parameters directly from the schedule and assign them to the Rooms/Doors categories.  By the way, you don't need to use shared parameters for any of those fields, everything can be added as non-shared parameters directly in the project's schedule.

Nachricht 8 von 17
Sahay_R
als Antwort auf: ToanDN

I just assigned them to Furniture. How did you edit the parameters right out of the schedule?

(Hang on - I see them as Shared Parameters assigned to Furniture and Rooms in your project....)

And also - those parameters come from the Families, and if they aren't Shared I can't schedule for that parameter....


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 9 von 17
ToanDN
als Antwort auf: Sahay_R

Fields tab, select the parameter, Edit button, tick Add to all... box, then tick the category box(es).
Nachricht 10 von 17
Sahay_R
als Antwort auf: ToanDN

Aahh. Another way to add a Shared parameter to the project..... Thank you!


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 11 von 17
Sahay_R
als Antwort auf: ToanDN

And now what's wrong with this?

Capture.PNG

 

This is the desired result....

Capture.PNG


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 12 von 17
ToanDN
als Antwort auf: Sahay_R

You cannot divide by zero.
Nachricht 13 von 17
Sahay_R
als Antwort auf: ToanDN

After coming so far.....

What would you suggest? Creating hidden fields for Total Existing and Total Proposed, and using them in a calculated field for the Percentage Decrease?> My head hurts now......


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 14 von 17
ToanDN
als Antwort auf: Sahay_R

I suggest you use the furniture schedule to get the count of the new pieces, then re-enter them in a room schedule to get the calculated % and whatnots.
Nachricht 15 von 17
Sahay_R
als Antwort auf: ToanDN

Would that mean stitching the two schedules together on the sheet? A FrankenSchedule, so as to speak?


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 16 von 17
ToanDN
als Antwort auf: Sahay_R

Since you have to re-enter the values to the room schedule anyways so just use one schedule.  Keep the furniture schedule for validation should the design changes.

 

Annotation 2019-12-09 124800.png

Nachricht 17 von 17
Sahay_R
als Antwort auf: ToanDN

Right - that's what I did - created two hidden fields, manually entered the numbers in there to feed the calculated parameter that gave the percentage decrease values. All is well now. 


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.

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