URGENT! Schedules - Footer Totals - calculation does not add up

[laurenk]

I have created an Area Schedule which calculates the total area - as selected in the Formatting tab. (see attached)

The Area's read:

48

43

37

The Footer (totals checkbox) reads:

Total 127

As you can see the total is incorrect. This is likely not using the rounded values in the schedule, but calculating based on the true decimal value of each Area.

ie. 47.6 + 42.6 + 36.6 = 126.8 which rounds to 127

How can I adjust this to calculate the value as a rounded figure based on the scheduled values?

ie. 48 + 43 + 37 = 128

We require this for calculating areas for SALES CONTRACTS - purchasers enter a contract based on the ROUNDED figures.

It needs to be correct for Legal purposes.

Can someone please advise how we can proceed without using a text line for the totals??????

[barthbradley]

See that box that's checked for Project Units: UN-CHECK IT. Then round to 1 decimal place...or 2...or 3...or...am I possibly not understanding the issue?

[laurenk]

We want each Area to round to 1.

We want to calculate the totals of the rounded areas.

ie.
Area 1.1 = Area rounded to 1
Area 1.6 = Area rounded to 2
Area 1.6 = Area rounded to 2

Total based on decimal areas 1.1 + 1.6 + 1.6 = 4.3 (rounded to 4)
Total based on rounded areas = 1 + 2 + 2 = 5

When we select the footer to calculate totals - it reads the total based on decimal areas = 4 

We want a total based on the rounded areas = 5

Any ideas please?

[David_W_Koch · Accepted solution]

Add a calculated value column to your schedule table, based on your area parameter [round(Area / 1 SF) * 1 SF].  Total this column, and then hide the actual area column.  The total of the calculated value column will be the total of the calculated values, not the raw areas.

[barthbradley]

so the issue is that you want Revit to ROUND UP, not conventionally. Then assign a calculated value parameter field: ROUNDUP("AREA PARAMETER NAME"/1). That work for you? 

[laurenk]

Thanks so much David!
Alas, I wish we'd known this before the Contracts were issued.

[Keith_Wilkinson]

Surely the Revit total without things being rounded is the 'correct' total?  Essentially if you round up and get to 128 rather than 127 you are selling a m2 of floor space you don't actually have?  On a very large building this 'error' could become significant.

On our room areas we always show to 2 decimal places and total accordingly.

[laurenk]

This style of calculation is not determined by us mere architects.
We must conform with the standard.

[barthbradley]

Intriguing. Are you referring to an industry standard; perhaps an AIA contract standard? Can you cite that governing standard?

But nonetheless, clearly from a common-sense perspective: if all the quantities are rounded, then the reported quantities are skewed – and, as Keith rightfully points out:  significantly so depending on the unit of measurement. 

Thank God for CAD and BIM. I don't know what I would have done without them the last 25 years. Probably just rounded my guesstimates. 

[Keith_Wilkinson]

Yes, it would be interesting to see the standard that promotes this approach. Do you have a reference @laurenk?

[laurenk]

I will assume you are in a different state, country and timezone.
I dont have time to debate.

[Keith_Wilkinson]

It wasn't really a debate, just a link to the standard for other peoples reference would have been useful all round. Remember people have given up their time to help you with something, it's sometimes nice to do the same in return. But hey ho, it's up to you.

[laurenk]

I do appreciate your help Keith.
As mentioned earlier, the measurements are based on local real estate sales standards not architectural standards. I would provide these if i had time. Busy busy.

[Keith_Wilkinson]

Can you at least let us know what state you are in so that we can avoid buying a house or renting and office there? ;o)

[ToanDN]

They are most likely self-made rule by developers. When a buyer questions the accuracy of the reported area, they just say it is provided by the architect hurr durr...