Get Count % in Schedule

[Anonymous]

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.

[Sahay_R]

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.

[Anonymous]

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

[Sahay_R]

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.

[Anonymous]

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.

[Sahay_R]

Sigh. Please take a look at the attached file.

[Anonymous]

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!

[ToanDN · Accepted solution]

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.

[Anonymous]

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

[Sahay_R]

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.

[Anonymous]

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.

[Sahay_R]

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

[Anonymous]

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.

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

[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! 

[Anonymous]

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

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

[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 

[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?

[ToanDN]

---

@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.

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

[Anonymous]

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?

[ToanDN]

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.