topic Re: Get Count % in Schedule in Revit Architecture Forum

Get Count % in Schedule

Anonymous — Wed, 14 Feb 2018 15:22:07 GMT

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.

Re: Get Count % in Schedule

Sahay_R — Wed, 14 Feb 2018 15:40:11 GMT

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.

Re: Get Count % in Schedule

Anonymous — Wed, 14 Feb 2018 15:45:18 GMT

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

Re: Get Count % in Schedule

Sahay_R — Wed, 14 Feb 2018 15:57:04 GMT

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.

Re: Get Count % in Schedule

Anonymous — Wed, 14 Feb 2018 16:09:00 GMT

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.

Re: Get Count % in Schedule

Sahay_R — Wed, 14 Feb 2018 16:22:32 GMT

Sigh. Please take a look at the attached file.

Re: Get Count % in Schedule

Anonymous — Wed, 14 Feb 2018 16:27:30 GMT

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!

Re: Get Count % in Schedule

ToanDN — Wed, 14 Feb 2018 16:37:18 GMT

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.

Re: Get Count % in Schedule

Anonymous — Wed, 14 Feb 2018 16:43:18 GMT

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

Re: Get Count % in Schedule

Sahay_R — Wed, 14 Feb 2018 16:52:37 GMT

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.

Re: Get Count % in Schedule

Anonymous — Wed, 14 Feb 2018 16:57:16 GMT

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.

Re: Get Count % in Schedule

Sahay_R — Wed, 14 Feb 2018 17:32:28 GMT

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

Re: Get Count % in Schedule

Anonymous — Mon, 15 Apr 2019 20:09:57 GMT

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

Re: Get Count % in Schedule

Anonymous — Mon, 15 Apr 2019 20:20:19 GMT

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!

Re: Get Count % in Schedule

Anonymous — Mon, 15 Apr 2019 21:05:05 GMT

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

Re: Get Count % in Schedule

Anonymous — Mon, 15 Apr 2019 21:11:07 GMT

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

Re: Get Count % in Schedule

Anonymous — Mon, 15 Apr 2019 21:26:09 GMT

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?

Re: Get Count % in Schedule

ToanDN — Mon, 15 Apr 2019 22:38:34 GMT

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

Re: Get Count % in Schedule

Anonymous — Wed, 17 Apr 2019 19:40:08 GMT

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?

Re: Get Count % in Schedule

ToanDN — Wed, 17 Apr 2019 19:51:57 GMT

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.