topic Re: Add a row inschedule for percentage calculation in Revit Architecture Forum

Add a row inschedule for percentage calculation

Anonymous — Mon, 06 Feb 2017 05:23:46 GMT

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

Re: Add a row inschedule for percentage calculation

rudi.roux — Mon, 06 Feb 2017 09:31:44 GMT

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!

Re: Add a row inschedule for percentage calculation

Anonymous — Mon, 06 Feb 2017 10:28:21 GMT

Hi Rudi,

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

Thank you.

Re: Add a row inschedule for percentage calculation

FGPerraudin — Mon, 06 Feb 2017 10:30:30 GMT

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

Re: Add a row inschedule for percentage calculation

rudi.roux — Mon, 06 Feb 2017 10:48:13 GMT

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!

Re: Add a row inschedule for percentage calculation

RDAOU — Mon, 06 Feb 2017 11:41:13 GMT

@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

Re: Add a row inschedule for percentage calculation

FGPerraudin — Mon, 06 Feb 2017 11:40:06 GMT

@RDAOU

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

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

Re: Add a row inschedule for percentage calculation

Anonymous — Mon, 06 Feb 2017 14:08:07 GMT

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.

Re: Add a row inschedule for percentage calculation

rudi.roux — Mon, 06 Feb 2017 14:22:02 GMT

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.

Re: Add a row inschedule for percentage calculation

RDAOU — Mon, 06 Feb 2017 16:26:51 GMT

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

Re: Add a row inschedule for percentage calculation

Anonymous — Mon, 06 Feb 2017 16:49:16 GMT

Thanks rdaou.

Appreciate if you could screencast step by step.

Sorry I cant share model.

Re: Add a row inschedule for percentage calculation

rudi.roux — Mon, 06 Feb 2017 23:30:02 GMT

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!

Re: Add a row inschedule for percentage calculation

Anonymous — Tue, 07 Feb 2017 05:32:53 GMT

Hi Rudi,

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

Here's what I'm looking at :

3587.49 / 5279.39 = %

Re: Add a row inschedule for percentage calculation

Anonymous — Tue, 07 Feb 2017 05:42:52 GMT

Hi Rdaou,

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

Thanks

Re: Add a row inschedule for percentage calculation

RDAOU — Tue, 07 Feb 2017 10:19:19 GMT

@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

Re: Add a row inschedule for percentage calculation

Anonymous — Thu, 09 Feb 2017 11:01:19 GMT

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.