True vs Rounded

[ar999ar]

Hi,

Revit calculates areas of Rooms. Units are set to 2 decimal places for Rounding. And it writes so into Room Schedule. But looks like it keeps the real area values in mind and uses them in Totals. Because if I recalculate totals on calculator I get different values than Revit’s calculated. Look at example I did.

That’s nothing but sometimes problems appear when I need to manipulate numbers in reports.

Is there any possibility to make Revit keep in mind and use rounded numbers too?

Thank you.

[barthbradley]

So you changed the unit precision under Formatting tab? 

---

@ar999ar wrote:

Is there any possibility to make Revit keep in mind and use rounded numbers too?

---

You could create a Calculated Parameter column (e.g. "Rounded Area TTL") with a Formula that rounds the Area Values.  

[MostafaElashmawy]

Somebody wrote a genius method in below link.

https://forums.autodesk.com/t5/revit-architecture-forum/round-up-calculated-total-of-revit-schedule-...

read his method and try to adapt it.

[ar999ar]

If I'm right, problem is not in showing or rounding fields in Schedule. Problem is that Revit calculate totals from rooms, not from lists in Schedule. 

I attach picture, where real area is marked in Properties window.

[barthbradley]

Why does it matter? 

[ar999ar]

That is important when making reports. My colleague groups rooms into different groups and calculate their totals. And sometimes he comes to situation when he writes "there are XXX,XX sq. meters", but Schedule on sheet shows that there are YYY,YY sq.m. As bigger project is, as bigger miss appears. So we think what to do - find right parameter or return back to manipulations  🙂

[SteveKStafford · Accepted solution]

See image, I created a Calculated parameter that rounds the Area value down to the nearest SF. This values total will provide a calculated total that matches the total of each value shown in the column. Whether you round down or up it will still be important to explain that the total area of the building (compared to total room area) most likely will not match a calculated total if they do their own calculations based on the building's proportions.

[barthbradley]

---

@ar999ar wrote:

That is important when making reports. My colleague groups rooms into different groups and calculate their totals. And sometimes he comes to situation when he writes "there are XXX,XX sq. meters", but Schedule on sheet shows that there are YYY,YY sq.m. As bigger project is, as bigger miss appears. So we think what to do - find right parameter or return back to manipulations  🙂

---

Did you read through my very first post? Calculated Parameter doesn't do the trick for you? 

[ar999ar]

Oh, looks it's a solution.
Pictures helps  🙂

thank you 

[SteveKStafford]

Yes, @barthbradley original reply is what my picture shows. Room area is based on the room's boundary. The separate parameter and rounding allows for the subtle separation needed for the departure from actual area and total area to a subjective abstraction of it.

[ar999ar]

Needed to return. 
That new separate parameter must be rounded to 2 decimal places, but I can't find how to do it. 

Formula: rounddown(Area / 1 m²) gives 0 places. Tried few options - no result.

Any ideas?

thanks 

[ToanDN]

Formatting tab > Select the parameter > Field Format button.

[barthbradley]

Field Format.  

[David_W_Koch]

---

@ar999ar wrote:

Needed to return. 
That new separate parameter must be rounded to 2 decimal places, but I can't find how to do it. 

Formula: rounddown(Area / 1 m²) gives 0 places. Tried few options - no result.

Any ideas?

thanks 

---

You may have sorted this out by now, but for others coming across this thread who want to use a calculated value that rounds to a given decimal place, rather than a whole number, what you need to do is multiply the initial number by ten raised to the number of decimal places you want, round that number, then divide by that same factor.

For example, say the raw area is 123.4567 square feet, and you want to round down to two decimal places.  First multiply the raw area number by 100 (ten to the second power), giving 12345.67 square feet.  Apply the rounddown to that value, giving 12345 square feet, then divide that by 100, to get 123.45 square feet.  More details can be found in this blog article, if you are interested.  (That article also shows how to process an area value, which has units attached to it, in the Revit rounding functions, which require numeric input with no units.)

Similar techniques can be used to get rounding to other values.  For example, to round the the nearest 5 square feet, divide the number by 5, do the rounding, then multiply the result by 5.

[mrogoffNEBMU]

Manage / Project Units / Area

see attached snapshot