Donate Now Goal amount for this year: 2500 USD, Received: 1627 USD (65%)

Results 1 to 3 of 3

Thread: How to create Calculated value formula

  1. #1
    New Member
    Join Date
    August 14, 2018
    Posts
    1
    Current Local Time
    11:39 PM

    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

  2. #2
    Forum Addict GMcDowellJr's Avatar
    Join Date
    December 21, 2010
    Location
    Phoenix, AZ
    Posts
    2,603
    Current Local Time
    11:09 AM
    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

  3. #3
    Forum Addict josephpeel's Avatar
    Join Date
    May 3, 2012
    Posts
    1,401
    Current Local Time
    08:09 PM
    There are several threads about a solution to this.
    https://www.revitforum.org/architect...unt-total.html

    (Also known as the "Total Mayhem" solution, so you can search for that too.)

Similar Threads

  1. Replies: 2
    Last Post: November 18th, 2016, 01:24 PM
  2. Improper use of Boolean Expression message with my calculated value formula
    By sippel26 in forum Architecture and General Revit Questions
    Replies: 5
    Last Post: February 13th, 2014, 07:20 PM
  3. Help with my formula in calculated Value
    By sippel26 in forum Architecture and General Revit Questions
    Replies: 3
    Last Post: January 29th, 2014, 06:56 PM
  4. Calculated Value
    By ralbanesi in forum Architecture and General Revit Questions
    Replies: 14
    Last Post: December 13th, 2012, 09:10 PM
  5. Schedule formula (is there a formula expert in the house?)
    By John McCamont in forum Architecture and General Revit Questions
    Replies: 8
    Last Post: September 9th, 2011, 09:50 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
  •