Use 'Count' in Revit Schedule Formula Tutorial

In this BIG "BAD" BIM Tip of the Week Peter shares an awesome tip that lets you use the "Count" value in Revit schedule for calculations in a Revit formula.

Thanks for sharing this Use "Count" in Revit Schedule Formula Tutorial , Peter!!

My Current Hardware/Software:

[kanders]

Or you can make new Calculated Value "Total Cost" with formula: [Cost] and in formating turn on Calculating totals. Result is the same, just faster and easier.

[integvis]

Nice one. I had added an integer parameter to my families with value 1 to achieve the same goal, but this is even easier. THANK YOU!!!

[jerryaiquipacarrasco]

What a simply and fascinating solution. So creative!

[ed_chaves]

Thank you! The trick helps me once again.

[AP_Corsa]

nice tip👍Solved my long-standing confusion

[eeckie]

I'm looking how to add volumes to the pipe schedule but I can't find it anywere? Do you have any idea?

[bivieo]

Thanks man for good job! you save me times!

[pamilerinsulaiman]

Amazing tutorial, thank you so much for this insightful video 👏👏

[rodrigothorus]

How can I sort data by this new count and apply a filter for values greater than a specific number? My issue is that the filter seems to consider counts equal to 1 instead of the total count. Can you provide guidance on how to handle this in more detail

[PhucHoang-hbhs]

thanks a lot, you really helped me with this problem)))

[pmkconsultant]

I tried this trick and can't seem to get it to work. It seems to work with a single calculation, i.e., Count New * X, but I can't do multiple functions in a single formula. I've tried a formula: 1 / ((1 / Transformer Impedance) * My Count), but it just won't do more than one function?

[aagfx]

you don't know how I can say thank u man!

[seenahassouna]

Thank you. I tried this for areas but it said inconsistent units when I made the formula for Area/Count New. I've got 10 rooms with the same name but slightly different areas so I'm trying to show an average individual area. As in 10 offices at 110 SD

[melatubino]

Hi!
This is not exactly regarding formulas, but I think you can help me!!!!
I wanted to organize my schedules and I created several schedule types (system family: type) and they were useless, I discovered after that I must create schedule view templates instead.
BUT now I have like 10 different schedule types which I can’t purge. I haven’t find how to purge them.
Any suggestions? I did it on my template 😢
Thanks you!!!!

[iraqiguns]

Now is there a way to add the count "New count" to a Multi category tag? I would like to see the quantity of each item on the tag itself

[MrSpartak]

thanks, we need count value for another calculations

[Alyce-lgxk]

Thank you so much!! You saved us so much anger!

[chinhnguyenphuc]

The "Count New" step is unneccesary. Simply by changing the format to "Calculate totals" works. It's a built in function that will multiply by "Count". In this example make a new calculated parameter field "Total Cost". Set that formula to Cost. Set formatting to "Calculate totals".

[Gonzo]

hide "count new" column and you're good to go! ; )

[jeffreysargis]

Anyone else getting "improper use of boolean expressions" when trying this?