RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

248 Users Online (86 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM

 

Forums

Forums >> Revit Building >> Technical Support >> Schedule totals are not calculated right: 1+1=1

Search this ThreadSearch this Thread | Page 2 of 2 | << Previous 1 | 2

Fri, Dec 5, 2008 at 10:00:23 PM | Schedule totals are not calculated right: 1+1=1

#16

jhemberger


active

Joined: Mon, Oct 29, 2007
7 Posts
No Rating


I have a similar adding issue, mine however occurs in my occupancy load schedule.  I set up a calculated value field that calculates occupancy load with the formula of (Area / Occupancy Factor) + 0.4999 and I also have a field next to it for the tag to read that is a manual data entry column.  As you can see the grand total as stated earlier in this thread is not adding correctly (see attachment).  I went trough the steps above for creating a area schedule and that seemed to work, but in the case of occupancy load shown here it seems either I didn't apply the theory correctly from above or it doesn't work in this case. 

 

From what I can tell the Subtotals and Grand Totals are adding the actual numbers not the rounded numbers to reach the number they round up/down from.  (ie: the actual numbers for the two subtotals add up to somthing like 37.55 and 34.60, which are then rounded up to 38 and 35.  However the Grand Total of all actual numbers equals 72.15, this is rounded to 72 and not 73 as it should be if you add up the rounded numbers. 

 

Can Revit be told to alway round up?

 

 Any guidance Lunchtrayrider or others?

 

Joshua



Attached Images

49334_Occupancy_Schedule.jpg

This user is offline

 

Fri, Dec 5, 2008 at 11:47:43 PM | Schedule totals are not calculated right: 1+1=1

#17

lunchtrayrider


active

Joined: Mon, Jun 25, 2007
592 Posts
3.5 Stars: 7 Votes


I'm typing this as I'm reading it in order to better understand what you want.

 

your taking the area/occupancy factor to find the total occupants.  then your using the .4999 to round up.  sounds good so far.

 

now you've got a number that is rounded that you want to add as it appears. (i.e. no mystery decimals you can't see)

 

here is the theory explaination of what I did before:

 

when you take the area and divide it by an occupancy factor im guessing that you took something like 250sf/10.  now the answer to that is 25.  right? wrong.  its 25sf.  the sf is important.  the area integer i did in my previous explaination took the number 25sf and made it 25 by dividing by 1sf.  

 

so what I would do is (im paraphrasing from the previous post too so pay attention to that)

 

take your area sf and then divide by the occupancy factor (forget the .4999 right now.

now create a occupancy integer field and for the equation make it (calculated occupancy load field+ .4999) /1sf

 okay now create another field that is occupancy rounded and make its equation occupancy integer * 1sf

 

hide the occupancy factor whatever field and the occupancy integer field.   display only occupancy rounded column (you can change its display name to occupancy load.

 

the workaround of the /1sf and the *1sf removes the hanging mystery decimals.

 

if it does/doesn't work for you let me know.

 


-----------------------------------
I like scooters. and motorcycles.

This user is offline

 

Tue, Apr 21, 2015 at 6:27:21 PM | Schedule totals are not calculated right: 1+1=1

#18

alabaster2513


active
alabaster2513 Avatar

Joined: Tue, Jan 16, 2007
1009 Posts
3.5 Stars: 25 Votes


I know I'm opening an old can of worms here but I am struggling with rounding totals on plumbing fixture calcs.

 

For example I have 10 rooms that come out in ranges of 0.01 to 0.08 totalling 0.3375. In theory for required fixtures this would be 1. BUT, in a calculated grand total rounded to 0 decimals it returns 0. I have tried the ROUNDUP function in my calculation but it rounds up each individual room and returns a grand total of 10. Does anyone know a way to roundup a grand total not the instances?


This user is offline

View Website

Search this ThreadSearch this Thread | Page 2 of 2 | << Previous 1 | 2



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Calculated totals of formula in schedule

Revit Structure >> Technical Support

Fri, Sep 11, 2020 at 12:14:07 PM

7

which parameters can have totals in schedules?

Revit Structure >> Technical Support

Fri, Nov 8, 2013 at 4:37:49 PM

2

Schedule Totals

Revit Structure >> Tips & Tricks

Wed, Jan 6, 2010 at 8:00:46 PM

1

Calculated Values

Revit Building >> Technical Support

Mon, Mar 3, 2008 at 5:01:17 PM

0

totals in area schedules

Revit Building >> Technical Support

Thu, Nov 6, 2014 at 7:28:50 PM

1

Site Stats

Members:

1668284

Objects:

22121

Forum Posts:

151721

Job Listings:

3

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 3.1077

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights