Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Get Count % in Schedule

19 ANTWORTEN 19
GELÖST
Antworten
Nachricht 1 von 20
Anonymous
5046 Aufrufe, 19 Antworten

Get Count % in Schedule

Hi,

 

I have 129 Units and 5 Unit Types, I need to get the % of each Unit Type based on the Grand Total,

any ideas? Thanks.

 

Capture.PNG

19 ANTWORTEN 19
Nachricht 2 von 20
Sahay_R
als Antwort auf: Anonymous

Set up a Calculated Parameter to calculate the percentages - in the Calculated Value dialog box, it will give you the option for Percentage and offer a choice of parameters and Grand Total to calculate it.

 


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 3 von 20
Anonymous
als Antwort auf: Sahay_R

it doesn't let me to select Count as percentage of...

Nachricht 4 von 20
Sahay_R
als Antwort auf: Anonymous

Add a new number parameter. Call it Number. Combine this with Count. In the schedule, the value of Number will be equal to Count. Hide Count. You will be able to select Number to calculate the percentage.


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 5 von 20
Anonymous
als Antwort auf: Sahay_R

so i created a Number parameter, named it Number,

 

I created a combination of Number and Count and named it Com,

 

i created a calculated value, now i have to select Com as % of grand total, correct?

 

but it doesn't let me, i mean there's no Com there, i can see Number tho, but it doesnt work.

Nachricht 6 von 20
Sahay_R
als Antwort auf: Anonymous

Sigh. Please take a look at the attached file.


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 7 von 20
Anonymous
als Antwort auf: Sahay_R

how does this work exactly?

i'm sure you can see that even in your file the % is 0.

if you have 3 rooms the percentage of each should be %33!

 

Capture.PNG

Nachricht 8 von 20
ToanDN
als Antwort auf: Anonymous

Unfortunately you cannot include Count in any calculated value.  You need to create a new number parameter [My Count], add to the schedule, select all rows (or group by this field) and enter 1 for it.  Then you can use this new value for calculate the %.  Let me know if you need an example.

Nachricht 9 von 20
Anonymous
als Antwort auf: ToanDN

Hats off Toan!!! thank you so much sir.

Nachricht 10 von 20
Sahay_R
als Antwort auf: ToanDN

Oops! Even combining Count with another parameter does not work. What I would do would be to delete the combined parameter and manually enter the numbers into the new parameter and that would be recognized by the percentage formula.


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 11 von 20
Anonymous
als Antwort auf: Sahay_R

This is Revit and I'm one of those who's against doing anything manually in it.

It's not good when people are using Revit with AutoCAD mentality.

Nachricht 12 von 20
Sahay_R
als Antwort auf: Anonymous

Correct. Unfortunately - as you have already experienced - sometimes that is the only way out.....


Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 13 von 20
Anonymous
als Antwort auf: ToanDN

Hi @ToanDN,

 

I've been looking a way to count the views which have the parameter "ESTADO ING." assigned to "ok", to get the status percentage of the views checked.

 

image.png

 

Could you please post an example of the solution you mentioned in solving this topic? Is it applicable to my problem?

 

Any tip of advice will be very well received!.

 

Regards

Nachricht 14 von 20
Anonymous
als Antwort auf: Anonymous

first go to project parameters and create an instance parameter for rooms, number based ( call it Quantity)

then select your rooms in the view and assign "1" in that parameter for the rooms

then create a schedule for rooms, add name and etc, also add Quantity parameter too, with grand total

then create a Calculated Parameter, give it a name and put it on percentage, Of "Quantity", By "Grand Total"

then you have the % there, you can hide the Quantity in your schedule! 

 

Capture.PNG

Nachricht 15 von 20
Anonymous
als Antwort auf: Anonymous

Thanks, @Anonymous. This will help me a lot for a goal that I was looking in another project.

 

image.png

 

My goal here is that the Engineer assign "Ok" to the parameter "ESTADO ING." when the revision status of that particular view is completed. So, In this case, I need to get the percentage of only the views that have the parameter "ESTADO ING." = "Ok" compared to the grand total of the views.

 

Hope I explained what I'm looking for.

 

Thanks in advance

Nachricht 16 von 20
Anonymous
als Antwort auf: Anonymous

as far as i know, percentage only works with numeric parameters, you can ask them to put a number instead of "ok" so you can get the calculation. maybe others have a better solution. lo siento amigo 

Nachricht 17 von 20
Anonymous
als Antwort auf: Anonymous

thanks @Anonymous . That was my guess too... I was guessing if I could create a conditional parameter "If (param X == "OK" >>>>> Quantity = 1), is it possible?

Nachricht 18 von 20
ToanDN
als Antwort auf: Anonymous


@Anonymous wrote:

thanks @Anonymous . That was my guess too... I was guessing if I could create a conditional parameter "If (param X == "OK" >>>>> Quantity = 1), is it possible?


 

- Instead of using a text parameter for "OK", create a Yes/no parameter, name it OK, for the engineer to tick the boxes

- If you still want to show OK when the box is ticked, create a calculated text parameter and enter the formula:

if (OK, "OK", "not OK")

- Create another calculated number parameter and enter 1 in the the formula

 

Example 2019 file.

 

Annotation 2019-04-15 153703.png

- Create the last calculated parameter and set it to Percentage as described.

Nachricht 19 von 20
Anonymous
als Antwort auf: ToanDN

Thanks, @ToanDN.

 

I took your directions and got almost what I wanted. In your example, you are counting every item as "1" so it matches the 25% each and it is correct. The result I want, is that if it is "not OK">>>> Count = 0 and the percentage of completion is 75% of 100%.

 

In your example, if you put 0 to the Count parameter for "not OK", it will get 33.3333% for the three above.

 

Do you think is it possible to do what I'm looking for?

 

 

Nachricht 20 von 20
ToanDN
als Antwort auf: Anonymous

Yes. Just add another calculated value column and use formula: if(OK, 1, 0). You still use the original Count value = 1 to get the correct %, but hide the column in the schedule. Now your schedule show the new Count column with 0 and 1 for OK and not Okay respectively, and the % column.

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report