Announcement

Collapse
No announcement yet.

Can Revit summarize Grand Totals?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Can Revit summarize Grand Totals?

    Hi all

    I have few different schedules of weights and each has a grand total value. Is there a way to summarise those totals somehow? (Apart from using Windows Calculator)
    Attached Files

    #2
    If you are using the same shared parameter for all the weights, you should be able to create some kind of multicategory schedule sorted by category. You'd need to figure out what filters make the most sense to just include those objects as well.

    Comment


      #3
      Yes it can make grand summaries.
      In the Schedule you can modify either the "sorting" to calculate totals, and also itemize each instance (or not) and how to seperate the fields also (header/footer)
      Also in the "formatting" tab of the Schedule you can tell it to calculate totals for a specific value (that are not necessarily in your sorting fields) and it can calculate totals, minimums, maximums etc... Sorry for the image I only have a french version installed but the tabs and buttons are all in the same place on your interface.

      I can also add a conditional statement in the formatting tab, I can say
      - if value > 100 then make column red (for example)
      Then I will see immediately any items that have exceeded my conditional value highlighted in red in the totals column.
      Attached Files

      Comment


        #4
        Originally posted by Karalon10 View Post
        Yes it can make grand summaries.
        In the Schedule you can modify either the "sorting" to calculate totals, and also itemize each instance (or not) and how to seperate the fields also (header/footer)
        Also in the "formatting" tab of the Schedule you can tell it to calculate totals for a specific value (that are not necessarily in your sorting fields) and it can calculate totals, minimums, maximums etc... Sorry for the image I only have a french version installed but the tabs and buttons are all in the same place on your interface.

        I can also add a conditional statement in the formatting tab, I can say
        - if value > 100 then make column red (for example)
        Then I will see immediately any items that have exceeded my conditional value highlighted in red in the totals column.

        I'm not sure if you understood my question, or maybe I didn't understand your answer. What I want is to Add all the Grand Totals together, not how do calculate grand totals. For example, I want (Grand Total 1 + Grand Total 2 + Grand Total 3) = Sum of Grand Totals

        Comment


          #5
          no it is not possible.
          Dhilip Seshan
          +91 8124181665
          www.dhilipseshan.n.nu

          Comment


            #6
            Originally posted by gpktm View Post
            I'm not sure if you understood my question, or maybe I didn't understand your answer. What I want is to Add all the Grand Totals together, not how do calculate grand totals. For example, I want (Grand Total 1 + Grand Total 2 + Grand Total 3) = Sum of Grand Totals
            In a single category schedule it is not possible, Chris' answer above is your best bet, or export to excel and do it there.
            There are no stupid questions, only stupid people

            Comment

            Related Topics

            Collapse

            Working...
            X