topic Re: Revit Schedule Count with variable. HELP! in Revit Architecture Forum

Revit Schedule Count with variable. HELP!

stang — Tue, 26 Jul 2022 19:21:02 GMT

I have a apartment housing schedule that already adds up number of unit type with grand total.

I want to a different total in the same chart that shows the number of BF units.

I've set up a BF yes/no parameter, I tried to to do a calculated total, if(BF, Count, 0), but Revit refused to let me use Count for the calculation.

Can anyone think of something else that would work?

Re: Revit Schedule Count with variable. HELP!

ToanDN — Tue, 26 Jul 2022 19:25:20 GMT

You cannot use Count. Add a Calculated value integer parameter, name it Qty, then use the formula: if (BF, 1, 0)

Re: Revit Schedule Count with variable. HELP!

barthbradley — Tue, 26 Jul 2022 19:50:17 GMT

Why don't you just create a BF Parameter (Yes-No type) and assign it to the Category, and set the BF statuses in the Schedule. You can use Filtering rules to isolate a bunch of Rooms, uncheck Itemize every Instance, and change the BF Status of all of them in one fell swoop. When you are all done setting the BF Statuses, then Sort/Group and Subtotal by BF. There's only two BF conditions. Yes and No.

...if BF is already checked, then just Sort/Group and Subtotal by BF. If you want the Schedule to just show "Yes" or "No" BFs, then Filter one out of the Schedule via a Filter rule.

Re: Revit Schedule Count with variable. HELP!

stang — Tue, 26 Jul 2022 21:22:03 GMT

Thanks this works. I tried it before but set it to number instead of integer. and the result was literally 1 and 0. Now I really understand what Revit mean by number and integer...

Re: Revit Schedule Count with variable. HELP!

barthbradley — Tue, 26 Jul 2022 22:05:29 GMT

I don't understand the gymnastics. Why do you need the calculated parameter at all? It seems unnecessarily redundant. You can do what you want through Sorting/Grouping (maybe Filtering too, if you do not want to show non-BF Rooms in the Schedule) and Calculate Totals for Count.