Announcement

Collapse
No announcement yet.

How to create Calculated value formula

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    How to create Calculated value formula

    Hello all,

    How to create calculated value in Schedules by using Count parameter? I knew that count cannot be used as a fields but any other alternate method is available to proceed further. Please help me in this case.

    Thanks in advance
    Tags: None
    #2
    You can’t.

    You can work around it by setting a new calculated value to 1, totaling that column, then another calculated value that shows to percentage of the “1” parameter relative to the total/sub-total, and finally one more calculated value that takes the invert of the percentage (1/%) which will give you the total/subtotal in each row.

    That was from memory so I might have missed something... if I remember I’ll share an example later today.


    Sent from my iPhone using Tapatalk
    Greg McDowell Jr
    about.me/GMcDowellJr

    Comment

      #3
      There are several threads about a solution to this.
      Revit Forum
      https://www.revitforum.org/architecture-general-revit-questions/29833-schedule-calculating-average-m2-count-total.html


      (Also known as the "Total Mayhem" solution, so you can search for that too.)
      "One must imagine Sisyphus happy." Albert Camus - "The innovator has for enemies all those who have done well under the old conditions, and lukewarm defenders in those who may ​do well under the new." Nicolo Machiavelli -"Things that are too complex are not useful, Things that are useful are simple." Mikhail Kalashnikov

      Comment

      Previous template Next

      Related Topics

      Collapse
      Working...
      X