Add a row inschedule for percentage calculation

[Anonymous]

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

[rudi.roux]

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! 

[Anonymous]

Hi Rudi,

Thanks but I need to add a row above the Grand Total, not column. May I know how?

Thank you.

[FGPerraudin]

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

[rudi.roux]

Hi @Anonymous, 

As @FGPerraudin mentioned, there are limitations to rows in schedules. 

What you can do is the following: (To keep everything in Revit)

• Create Calculated Values (Percentages) for each Column as showed in my first post. 
• Then you can Create "Grand Totals" for each of the Data Totals(m²) which you're trying to get a Percentage for. 
• So, instead of the Percentages being displayed above the m², they will be displayed next to them. This will give you the result which you're after, or at least a workaround due to the limitations. 

Add Calculated Value/Percentages as shown below: 

I hope this helps! 

[RDAOU]

@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

[FGPerraudin]

@RDAOU

Iknow... have to say I start loving the tool!

But yes, maybe a bit too enthusiastic at the moment!

[Anonymous]

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.

[rudi.roux]

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. 

[RDAOU]

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

[Anonymous]

Thanks rdaou.

Appreciate if you could screencast step by step.

Sorry I cant share model.

[rudi.roux]

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. 

I hope this helps! 

[Anonymous]

Hi Rudi,

Thanks for screencast but I'm not looking at % per floor.

Here's what I'm looking at :

3587.49 / 5279.39 = %

[Anonymous]

Hi Rdaou,

Can you show me how you get the overall building percentage at 25.56%?

Thanks

[RDAOU]

@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

[Anonymous]

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.