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
Gelöst! Gehe zur Lösung
Gelöst von barthbradley. Gehe zur Lösung
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.
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?
Text Parameters cannot be used in formulas, but if they were numeric, you could write a Calculated Parameter formula like this:
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?
I want to get the total number of complete, by the grand total of How many panels there are..
how can I calculate total number of panels, as when i try to do a formula it wont let me use count in revit
Something like this? Showing 21 of 42 "completed" as a percentage (50%).
or maybe better this way:
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
@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.
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
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
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´
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.