This is one that catches out new and experienced Revit users alike, when you have a schedule that you want to show both a per unit column and a total count column.

A great example is this plumbing fixture schedule below

Usually the first thing a user will do is find their fixture unit parameter, in this case WFU, head over to the formatting tab of the schedule properties and check the ‘calculate totals’ box, which will give you something like this

This of course is not what you want, what you have here is the total fixture units for each plumbing fixture of a certain type without actually being told what the fixture unit for each individual fixture is.

To overcome this, you need to use a calculated value to show the per unit count.

In the schedule properties dialogue, under the fields tab, select Calculated Value.. as shown at 1 in the image below.

Next, I’m going to name our calculated value to be ‘Fixture Unit Rating’ and because in this instance we want to know the per unit count is the parameter ‘WFU’ we simply need to type in WFU into our formula as shown at 2 in the image below.

Finally, at 3 in the image above we have our per unit fixture rating in our 3rd column and our total fixture unit count for each fixture type, as well as our grand total of fixture units in our 4th column.