Hi,
I wish to add a row above grand total in schedule to show % area calculation. Summation of each column divide by total building area(5279.27)
Eg:
3587.48/5279.27= 67.9%
942.29/5279.27=1.8%
749.5/5279.27=14.2%
Pls advise steps to do it.
Thaniks
Hi @Anonymous,
Hope you are well! ![]()
What you need to do is to add a Calculated Parameter/Value to your Schedule.
Go to your Schedule, Click on Edit Fields, or Insert a new Column >> Calculated Value >> Select Percentage >> Then Select Percentage Of: e.g - Area Divided By: Area <Grand Total> and click ok.
This will then give you the result which you're after. e.g - 84/140 = 60% (as per the sample below:
I hope this helps! ![]()
Rudi Roux
MSc | Digital Engineering Manager
LinkedIn
Revit Mechanical & Electrical Systems 2018 Certified Professional | Revit MEP & Architecture 2015 Certified Professional
AutoCAD 2015 Certified Professional | Autodesk Building Performance Analysis (BPA) Certificate
If this post resolved your issue, kindly Accept as the Solution below. Kudos are always welcome ⇘
Hi Rudi,
Thanks but I need to add a row above the Grand Total, not column. May I know how?
Thank you.
hi @Anonymous,
Sadly Revit will not let you add a customized total (as it is what you want to get).
If I were you, I would export the data into excel.
You can use dynamo to do that, and get a live feed from Revit to excel.
François
Francois-Gabriel Perraudin
BIM management and coaching
Hi @Anonymous,
As @FGPerraudin mentioned, there are limitations to rows in schedules.
What you can do is the following: (To keep everything in Revit)
Add Calculated Value/Percentages as shown below:
I hope this helps! ![]()
Rudi Roux
MSc | Digital Engineering Manager
LinkedIn
Revit Mechanical & Electrical Systems 2018 Certified Professional | Revit MEP & Architecture 2015 Certified Professional
AutoCAD 2015 Certified Professional | Autodesk Building Performance Analysis (BPA) Certificate
If this post resolved your issue, kindly Accept as the Solution below. Kudos are always welcome ⇘
@FGPerraudin I'm gonna start believing that you work on DynamoBim marketing team lol
@Anonymous it is a presentation thing? If it is you can simply duplicate and overlay schedulles to produce something similar... A customized total
YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION
Hi Rdaou,
Can you show me how you manage to get the last row %. I need to have % at bottom of each column like what you have shown.
Not sure what you mean by 'presentation thing', but looked like it worked in your video.
Hi Rubi,
% is not by level.
Perhaps I should create a separate schedule but how do I link new schedule to this current schedule so that grand total of each column can be expressed as a %.
Hi FGPerraudin,
I'm not so advanced to try Dynamo, ![]()
Maybe future.
Hi @Anonymous,
Are you at liberty to share the model via Dropbox or WeTransfer? Then I can help you out directly in your project. Otherwise, I'll revise my sample a bit to show you what can be done or to further elaborate on what I suggested. ![]()
Rudi Roux
MSc | Digital Engineering Manager
LinkedIn
Revit Mechanical & Electrical Systems 2018 Certified Professional | Revit MEP & Architecture 2015 Certified Professional
AutoCAD 2015 Certified Professional | Autodesk Building Performance Analysis (BPA) Certificate
If this post resolved your issue, kindly Accept as the Solution below. Kudos are always welcome ⇘
1. Duplicate the area schedule u have
2, on the new, add a calculated value column for the % next to each area column
3. Uncheck the itemize every instance (u get one line)
4. Hide all columns except the % columns
5 place both schedules on a sheet
Et Voila
I'm not at a computer at the moment maybe I will screencast all the steps when I'm back at my desk
YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION
Thanks rdaou.
Appreciate if you could screencast step by step.
Sorry I cant share model.
Hi @Anonymous,
Screencast and sample project attached for you reference. You can create percentage calculated values as per one of my previous posts next to each of your columns and then manipulate the schedules and percentages as you wish to fit your needs.
Rudi Roux
MSc | Digital Engineering Manager
LinkedIn
Revit Mechanical & Electrical Systems 2018 Certified Professional | Revit MEP & Architecture 2015 Certified Professional
AutoCAD 2015 Certified Professional | Autodesk Building Performance Analysis (BPA) Certificate
If this post resolved your issue, kindly Accept as the Solution below. Kudos are always welcome ⇘
Hi Rudi,
Thanks for screencast but I'm not looking at % per floor.
Here's what I'm looking at :
3587.49 / 5279.39 = %
Hi Rdaou,
Can you show me how you get the overall building percentage at 25.56%?
Thanks
@Anonymous
You hide the columns which you do not Need!!! we Show you the method but you Need to work it out following same steps on your Project!!
What @rudi.roux has put in a screencast is correct...if you follow same step and hide the % column for floors you will get what you want. You really need to put some effort in trying ![]()
otherwise attach your file and someone will do it for you. Take less time then posting 100 replies to this thread
YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION
I tried your method to create %columns but the % are not correct figures.
It should be grand total of each column divide by grand total of Column B.
Eg C/B, D/B, E/B, G/B, H/B.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.