Goal amount for this year: 2500 USD, Received: 1869 USD (75%)

# Thread: Get Count % in Schedule

1. ## Get Count % in Schedule

Hi,

i have 129 unit and 5 unit types, i created a schedule and sorted them by Unit Types,
now what i want is to create another column which shows the percentage of each unit type based on the total,
any ideas? thanks

https://www.revitforum.org/tutorials...-schedule.html
Not exactly what you're trying to do, but I think you should be able to adapt the concept.

3. You actually dont need a formula to do it at all. Just make a Calculated Value, and set it to "Percantage" instead of Formula, and make it a "percentage" of "Grand Total."

4. it won't let you to select Count as % of Grand Total.

5. it doesn't let me select Count for %, in order to do that, i have to combine it with another parameter,
and then the issue is that i can't use a combined parameter in formula.

6. ok , what i need to do is to create a new number parameter, select all the rooms and set that parameter as 1 for all of them,
then it'll let me select the new parameter in a calculated value as a percentage.

thanks guys.

7. You need a dummy parameter to take the place of Count:
https://www.revitforum.org/blog-feed...-schedule.html

8. Sorry, i forgot about that. To work around it i have a Shared Parameter called item_Count, and i used the Family Processor to go through my entire damn library, and set that value locked to 1 in every family i have, LOL. Makes using Count in a formula a bit easier.

9. If you don't want to add share parameters and all that just add a calculated value as Count: If(Area > 1,1,1)
Then do the percentage from this one

You don't need to update parameters or do anything else

10. A fixed Calculated Value does not really need a formula. Just write a '1'.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•