Results 1 to 10 of 10

Thread: Get Count % in Schedule

  1. #1
    Arsham
    Guest

    Not allowed! Not allowed!

    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
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture.PNG 
Views:	46 
Size:	4.3 KB 
ID:	32852  

  2. #2
    Moderator DaveP's Avatar
    Join Date
    January 10, 2011
    Location
    St Paul, MN
    Posts
    3,291
    Current Local Time
    11:02 AM

    Not allowed! Not allowed!
    This thread may help
    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. #3
    Administrator Twiceroadsfool's Avatar
    Join Date
    December 7, 2010
    Location
    Dallas, TX
    Posts
    11,017
    Current Local Time
    11:02 AM

    Not allowed! Not allowed!
    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. #4
    Arsham
    Guest

    Not allowed! Not allowed!
    it won't let you to select Count as % of Grand Total.

  5. #5
    Arsham
    Guest

    Not allowed! Not allowed!
    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. #6
    Arsham
    Guest

    Not allowed! Not allowed!
    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. #7
    Moderator cellophane's Avatar
    Join Date
    August 9, 2011
    Location
    Louisville, KY
    Posts
    6,389
    Current Local Time
    12:02 PM

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

  8. #8
    Administrator Twiceroadsfool's Avatar
    Join Date
    December 7, 2010
    Location
    Dallas, TX
    Posts
    11,017
    Current Local Time
    11:02 AM

    Not allowed! Not allowed!
    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. #9
    New Member
    Join Date
    July 31, 2017
    Posts
    1
    Current Local Time
    04:02 PM

    Not allowed! Not allowed!
    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. #10
    Senior Member ekkonap's Avatar
    Join Date
    May 23, 2011
    Location
    Netherlands
    Posts
    589
    Current Local Time
    05:02 PM

    Not allowed! Not allowed!
    A fixed Calculated Value does not really need a formula. Just write a '1'.

Similar Threads

  1. Sort Schedule by Count
    By Joshua Kohl in forum Architecture and General Revit Questions
    Replies: 3
    Last Post: June 30th, 2015, 06:13 PM
  2. Suffix behind count in schedule
    By boriskam1991 in forum Architecture and General Revit Questions
    Replies: 3
    Last Post: November 21st, 2012, 06:31 PM
  3. Schedule Count Question
    By mikey1073 in forum Architecture and General Revit Questions
    Replies: 2
    Last Post: September 19th, 2012, 04:19 PM
  4. Replies: 0
    Last Post: April 18th, 2012, 07:15 AM
  5. Schedule: Count only what's shown in schedule...
    By rkitect in forum Architecture and General Revit Questions
    Replies: 2
    Last Post: July 17th, 2011, 03:57 PM

Posting Permissions

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