Using Schedule Totals in Calculated Parameter Conditional Statement

[Jonathan_Drachenberg]

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' ".

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

[barthbradley]

Nested IF Statement:

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

[Jonathan_Drachenberg]

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?

[barthbradley]

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?  

[Jonathan_Drachenberg]

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.

[ToanDN · Accepted solution]

See revised file.

[HVAC-Novice]

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

[Jonathan_Drachenberg]

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

[Jonathan_Drachenberg]

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