What Revit Wants: Percentage of Item Count to Total Count in a Sched...

From Luke Johnson at What Revit Wants

Percentage of Item Count to Total Count in a Schedule

Let's say you have a number of different Door families in your project, and you want to determine the percentage of the total number of Doors that are Family 1, Family 2 etc, and then you want to show this in your Door Schedule.  First, sort by Family and untick 'Itemize every instance...', then use the process shown below.

In this workaround, a Calculated Value is added to be used as a 'constant' (it doesn't really matter what number is used here).  Then, another Percentage calculated value is created against that constant...

Count to grand total ratio in a schedule
Here is how you can do it.
1. Define a formula calculated value: Name - Workaround, Type - Number, Formula - 1.0; Hide the column showing this value
2. Define a percentage calculated value for Workaround.Leonid Raiz


via
Count to grand total ratio in a schedule - AUGI