Use "Count" in Revit Schedule Formula Tutorial

Подписаться 89 тыс.

Просмотров 25 тыс.

50% 1

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!!
Save 10% Off Your Enscape Subscription - enscape.bimafterdark.com/
Join the BIM After Dark Community for full courses, support, and sample files today - community.bimafterdark.com/
My Current Hardware/Software:
My Main Revit Computer (BIMBOX) - bimbox.bimafterdark.com/
How I Record My Tutorials (Camtasia Studio) - techsmith.z6rjha.net/zVvgW
My Microphone (Blue Yeti USB) - amzn.to/3992DYy
My Studio Headphones (Sennheiser HD 600) - amzn.to/2PxTFwj
My Camera for Videos and Images (Canon EOS 80D) - amzn.to/32zbpg5
The Lens I use for these videos (50mm) - amzn.to/3cvIE8D
My Webcam for Webinars (Logitech C922X) - amzn.to/2wP3AHf
My Favorite Sketchbook (“Blank” by 30x40) - amzn.to/32yAffZ
My Favorite Sketching Pens (Sharpie “Fine”) - amzn.to/3c8r8qO
Greatest Sketching Marker of All Time (Sign Pen) - amzn.to/3ceAukN
** Some of the above links are affiliate links, meaning you don’t pay anything more but I may get a small commission for a sale… Cheers! ** Music: Badass from Bensound.com

Опубликовано:

16 янв 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 58

@kanders94 2 года назад

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.

@viratmanchanda1645 Год назад

Thank you. This solves a big problem so simply! Amazing tip!

@TheRevitKid Год назад

Great to hear!

@integvis 4 месяца назад

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!!!

@TheRevitKid 4 месяца назад

Cheers! Great idea! Glad this helped

@jerryaiquipacarrasco8768 Год назад

What a simply and fascinating solution. So creative!

@TheRevitKid Год назад

Cheers!!!

@pamilerinsulaiman2279 Год назад

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

@TheRevitKid Год назад

Cheers! Thanks for tuning in!

@AP_Corsa 4 месяца назад

nice tip👍Solved my long-standing confusion

@ed_chaves Год назад

Thank you! The trick helps me once again.

@TheRevitKid Год назад

Cheers so glad!

@bivieo 2 года назад

Thanks man for good job! you save me times!

@TheRevitKid 2 года назад

Glad it helped! Thanks for watching.

@smpete0609 6 месяцев назад

this was a super helpful tip!

@TheRevitKid 5 месяцев назад

Awesome! So glad!

@Acip79 Год назад

Thanks a lot. Amazing tip 👌

@TheRevitKid Год назад

Cheers!

@PhucHoang-hb4hs Год назад

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

@TheRevitKid Год назад

Cheers! Glad I could help!

@ronwubbena4227 2 года назад

Thank you Sir!

@TheRevitKid 2 года назад

Cheers! Thanks for tuning in!!

@bloproject242 2 года назад

Thanks

@TJTP Год назад

Thank you very much

@TheRevitKid Год назад

You are welcome

@carlosmunoz1041 2 года назад

Awsome tip

@TheRevitKid 2 года назад

Glad you enjoyed !!

@broszillagaming3120 Год назад

thank you so much you saved me

@TheRevitKid Год назад

Great! Glad to hear it was helpful!

@SISNAM 9 месяцев назад

Thank you sir

@TheRevitKid 9 месяцев назад

Cheers!

@aagfx2958 8 месяцев назад

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

@TheRevitKid 8 месяцев назад

you just did! :)

@jericodino6404 2 года назад

Yeah Thank big help. :)

@Qwertyuiopasdfghjklzxcvbnm1984 4 месяца назад

Legend!

@TheRevitKid 4 месяца назад

🤘🤘

@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!!!!

@DesignsbyCADPRO 2 года назад

That's a cool trick... :)

@rodrigothorus4115 8 месяцев назад

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

@pmkconsultant 7 месяцев назад

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?

@Alyce-lg8xk Год назад

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

@TheRevitKid Год назад

Haha cheers! So glad I could help make you not angry! 😎

@eleuzeta1 Год назад

gracias!!!!!!!!!

@TheRevitKid Год назад

No problemo!!

@MrSpartak47 Год назад

thanks, we need count value for another calculations

@TheRevitKid Год назад

Cheers!

@seenahassouna8142 6 месяцев назад

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

@TheRevitKid 6 месяцев назад

Not sure your exact formula but if you are multiplying a SF by a foot … the result is foot cubed … so you have to divide to get it to be SF for example… again, not exactly sure your formula.

@iraqiguns 2 года назад

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

@TheRevitKid 2 года назад

Hmm.... if you are tagging one item won't it always show 1??

@iraqiguns 2 года назад

@@TheRevitKid No, for example I would like to tag (Chair A) which I have 5 instances of. I would like the tag to display 5 on it. and then if I add another instance of that chair then the tag would display 6 instead.

@paulschelechow4144 7 месяцев назад

Sort by count?

@sergechua1728 2 года назад

Neat

@terryjones4564 Год назад

I realized that you would get the same result by simply enabling calculate totals in the cost column. The reason the system value "Count" is not used in formulas is that is always = 1. 1 times anything is itself, therefore unnecessary. As an itemized line item 1 times the cost is the cost. The sum is achieved by enabling calculate totals on the Formatting tab of the Schedule Properties. Which is frustrating as what I wanted to do is calculate the area taken by furniture in a room and subtract it from the room area. Unfortunately the "calculated totals" sums can't actually be used in formulas only the value of the formula itself in the itemized list can be used. Oddly enough the system "Count" parameter automatically calculates totals without actually enabling it on the Formatting tab of the Schedule Properties.

@Gonzo558 Год назад

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

@chinhnguyenphuc5770 2 месяца назад

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