Percentages in Schedules

[AidanHawkins]

I am working on a 4 sided tower, where the facade is made of curtain walls with curtain panels on each level

I have created a curtain wall schedule

I have created 3 parameters for the curtain panels

Parameter 1 is a Yes/no parameter for weather the panel is complete or not

Parameter 2 is a text parameter that reports if the curtain wall is east, west, north or south

Parameter 3 is a text parameter that reports what level the curtain panel is on

How can I show in a schedule the count of the total that is yes for Parameter 1 / count of the total number of parameter 3 (which is the total number of panels) * 100

So I can show in a schedule the percentage of panels that are complete

[Alfredo_Medina]

What if instead of using a Yes/No parameter to indicate complete or not, you use an integer parameter, and enter 1 if the panel is complete. Then you can get the percentage of the count of that field compared to the total number of panels.

[AidanHawkins]

Ok thanks, but how do I do that?

I just want the count of the complete / count of the total panels on one side (that I have shown using my parameters)

Is it a formula in calculated values I have to use?

[barthbradley]

Text Parameters cannot be used in formulas, but if they were numeric, you could write a Calculated Parameter formula like this:

[AidanHawkins]

Could I make a parameter for the curtain panel and give each curtain panel the number 1

And then have a different parameter to show completion that gives a 1 to each one that is complete

And then get the percentage of completion by comparing these two? 

[AidanHawkins]

I want to get the total number of complete, by the grand total of How many panels there are..

[AidanHawkins]

how can I calculate total number of panels, as when i try to do a formula it wont let me use count in revit

[barthbradley]

Something like this?  Showing 21 of 42 "completed" as a percentage (50%).

or maybe better this way:

[AidanHawkins]

Exactly! How is it done?

[barthbradley · Accepted solution]

see attached rvt

[barthbradley]

you could do this too...

[AidanHawkins]

Yes thanks

But it is so annoying I cant just use count to do analysis in revit

With your way, I can never hide the percentage of  ´No´ and I cant make a presentable table

[ToanDN]

---

@AidanHawkins wrote:

Yes thanks

But it is so annoying I cant just use count to do analysis in revit

With your way, I can never hide the percentage of  ´No´ and I cant make a presentable table

---

Share how do you want your schedule to look and a revit file if possible.

[AidanHawkins]

Panels Level	North
01	20%
02	10%

This is an example of one of the schedules I want to produce. I would like to produce four (North, South, East and West) all the same.

Panels Level is a parameter that reports on what level each panel is on.

There is also another parameter working in the background that reports what elevation they are on (North South, East and West.)

And the percentages in Green are the amount of that are ´Yes´ in my Yes_No Completion Parameter out of the total number of panels that on that particular level and on that particular elevation side.

Many thanks, hope I am clear

[barthbradley]

Maybe this? 

[AidanHawkins]

Yes that could work for me

How is it done?

[barthbradley]

see attached

[AidanHawkins]

Thanks for this

I have begun to use it for my analysis

But it would be great if I could see number of complete by the number of panels per level

For example, at the end when everything is complete, I could see 100 percent in each cell for each level.

But thank you, this is good for now, I can just create a schedule for each level

[AidanHawkins]

How can you conditional format only one? I have looked at your model and these screenshots but I cant understand the steps

For example it will not let me change the colour if I place the test as ´None´