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: 

Using Schedule Totals in Calculated Parameter Conditional Statement

8 ANTWORTEN 8
GELÖST
Antworten
Nachricht 1 von 9
Jonathan_Drachenberg
550 Aufrufe, 8 Antworten

Using Schedule Totals in Calculated Parameter Conditional Statement

Please see the schedule below. I have it set so that the "Short Stud Combined Length" calculated parameter reports the calculated total (length * quantity) for any studs that are shorter than 4' length.

 

I need the "Special Condition" parameter to report on the Short Stud Combined Length calculated total, and to only provide notes on the short studs (less than 4').

If the Short Stud Combined Length is greater than 16', "Special Condition" should say "Length over 16' ".

If the Short Stud Combined Length is less than 4', it should say "Length under 4' ".

 

Jonathan_Drachenberg_0-1641592425998.png

 

How can I achieve this? Help would be much appreciated. Thanks!

8 ANTWORTEN 8
Nachricht 2 von 9

 

Nested IF Statement:

 

If(Short Stud Combined Length> 16', "Length over 16'", if(Short Stud Combined Length <4', "Length under 4'", ""))  

Nachricht 3 von 9

Thanks for your response. I understand that logic, the problem is that since the Short Stud Combined Length is reporting a calculated total on the schedule, the conditional statement is referencing the length of a single stud rather than the combined length. Therefore the Special Condition parameter reports "Length under 4'" for every stud.

 

Any idea how to fix this?

 

Jonathan_Drachenberg_0-1641615295456.png

 

Nachricht 4 von 9

Post the File.  

 

...you have my brain in a knot with that description. I figure it'll make more sense looking at the Schedule.  If you can't post, then describe the setup so I can create a facsimile of it on my end. 

 

edit...wait a minute. Are you trying to use the Grand Total value of the Column?  

Nachricht 5 von 9

I have attached an example model. Thank you for taking a look at this. Please see the schedule titled "Consolidated Stud Schedule."

 

Yes, I am trying to use the grand total value, which I know you normally can't do. I am looking for a workaround to perform the functionality I described above.

Nachricht 6 von 9
ToanDN
als Antwort auf: Jonathan_Drachenberg

See revised file.

ToanDN_0-1642792178647.png

 

Nachricht 7 von 9

I have no idea if it helps, but this reminded me of the most recent RevitKid video trick about using count in schedules.

 

Revit version: R2025.4
Nachricht 8 von 9
Jonathan_Drachenberg
als Antwort auf: ToanDN

That's awesome! Thanks for your help. Much appreciated!

Nachricht 9 von 9

Thanks for sharing! That doesn't help with this specific issue but it's a good tip to be aware of.

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