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

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

This user is offline

lunchtrayrider

active

Joined: Sun, Jun 24, 2007
592 Posts

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

alabaster2513

active

Joined: Tue, Jan 16, 2007
1009 Posts

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

Calculated totals of formula in schedule

7

which parameters can have totals in schedules?

2

Schedule Totals

1

Calculated Values

0

totals in area schedules

1