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??????
Gelöst! Gehe zur Lösung
Gelöst von David_W_Koch. Gehe zur Lösung
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?
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?
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.
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?
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.
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.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.