See the top rated post in this thread. Click here

Results 1 to 7 of 7

Thread: Count to grand total ratio in a schedule

  1. #1
    I could stop if I wanted to Archman's Avatar
    Join Date
    2003-08
    Location
    Dallas, Texas
    Posts
    255


    Default Count to grand total ratio in a schedule

    I would like to add a field in this shcedule that shows the ratio of the number of parking stalls of each type as compared to the total number of cars. Is this possible?
    Attached Images Attached Images
    Steve Valenta
    Associate
    HKS, INC.

  2. #2
    AUGI Addict DaveP's Avatar
    Join Date
    2002-12
    Location
    St Paul, MN
    Posts
    1,544


    Default Re: Count to grand total ratio in a schedule

    Sorry, no can do.

    You can't use a calculated value (like Count) in a formula.
    That's another long-standing Wish List item.
    The reason is, that Count field doesn't really exist. Its not a parameter, and thus can't be included in a Formula. Where would you put it in your Family?
    Go back to AutoCAD? I'd rather lose my right arm!

  3. #3
    I could stop if I wanted to Archman's Avatar
    Join Date
    2003-08
    Location
    Dallas, Texas
    Posts
    255


    Default Re: Count to grand total ratio in a schedule

    OK, I'm seeing that it's not possible to use "count" in a calculated value. Is there any other workaround that I'm not thnking of to acomplish this? All I really want is a ratio of each type of space to show up compared to the total. It seems simple in concept, but maybe I'm mistaken.
    Steve Valenta
    Associate
    HKS, INC.

  4. #4
    Revit Founder LRaiz's Avatar
    Join Date
    2003-07
    Location
    Newton, MA
    Posts
    714


    1 members found this post helpful.

    Default Re: 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.

    If this is a long standing wish list item then may be the recipe should be repeated in tricks and tips forum.
    Attached Images Attached Images
    Last edited by LRaiz; 2006-11-16 at 08:20 PM.
    Leonid Raiz

  5. #5
    Active Member
    Join Date
    2015-10
    Posts
    72


    Default Re: Count to grand total ratio in a schedule

    It works great!!!
    the only thing to consider is that with 3 objects with the same value each one of them will display 33% and that is 99% you loose 1% unless there is a way to change it to 33.33% which I do not know if you can on project units.

  6. #6
    Revit Founder LRaiz's Avatar
    Join Date
    2003-07
    Location
    Newton, MA
    Posts
    714


    Default Re: Count to grand total ratio in a schedule

    You can use Formatting tab in schedule properties to set desired precision of percentage display.
    Leonid Raiz

  7. #7
    I could stop if I wanted to Archman's Avatar
    Join Date
    2003-08
    Location
    Dallas, Texas
    Posts
    255


    Default Re: Count to grand total ratio in a schedule

    Thank you Leonid. As usual you have all the info I need. I think this should be a tip for the tips and tricks portal page.
    Steve Valenta
    Associate
    HKS, INC.

Similar Threads

  1. 2013: Combining material takeoff schedules / calc grand total for entire project in 1 schedule.
    By bart.oris266980 in forum Revit Architecture - General
    Replies: 1
    Last Post: 2014-04-28, 08:44 AM
  2. 2014: Can you eliminate a column grand total in a schedule but still grand total another column?
    By robinhill833400 in forum Revit Architecture - General
    Replies: 2
    Last Post: 2013-05-14, 04:05 PM
  3. Grand Total text format
    By avalencia60 in forum Revit Architecture - General
    Replies: 1
    Last Post: 2012-01-06, 07:43 PM
  4. Grand Total in schedules
    By Carlos GT in forum Revit Architecture - General
    Replies: 2
    Last Post: 2008-12-23, 01:59 PM
  5. How to have "Grand Total" in Schedule say something else?
    By luigi in forum Revit Architecture - General
    Replies: 1
    Last Post: 2005-08-02, 07:35 AM

Posting Permissions

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