Forums >> Revit Building >> Technical Support >> Schedule Count as Percent of Grand

hippy

active

Joined: Tue, Jan 17, 2006
41 Posts
No Rating

This seems an easy concept but when I enter the formula I get an error count cannot be used in formulas. I need to show  that "room name count" / "grand total count" as a percentive. Someone has to have a work-around.

Thanks

This user is offline

TomDorner

active

Joined: Sun, Apr 25, 2004
1207 Posts

The built-in field of count cannot be used in a percentage calculation as the result would be meaningless which is why they don't allow it.  In order to give meaning to a room count one needs to group the database report [Revit schedule] on a meaningful field such as 'department' and create your own field called room count which is an integer and calculate out a percentage of that when grouped by department.

Alternatively, you can get a built-in room count if you sort/group by department, room type, name etc.

Attached Images

-----------------------------------

Tom

www.reviteer.com   http://twitter.com/Reviteer

This user is offline

View Website

lpnoble

active

Joined: Fri, Feb 29, 2008
32 Posts
No Rating

Sorry but I have a brain freeze, I am trying to accomplish this very thing and this explanation hasn’t sunk into to my thick skull!

I have different types of rooms

I have the count of each room type in the schedule

I have the total rooms at the bottom of the schedule (calculate totals switched on)

How do I get the percent of the room type to the grand total?

This user is offline

lpnoble

active

Joined: Fri, Feb 29, 2008
32 Posts
No Rating

Well I did it!

This helped

http://forums.augi.com/showthread.php?t=50808&highlight=schedule+percentage+total

This user is offline

ROOM COUNT SCHEDULE

1

Area schedule question: "Grand total" in formulas...

0

Schedule Count Parameter

2

Grand total text

1

Schedules

1