Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Pipe Schedule calculated total length rounded up to the nearest 10m

tamas_borsay2
Explorer

Pipe Schedule calculated total length rounded up to the nearest 10m

tamas_borsay2
Explorer
Explorer

Hi!
I'm trying to create a schedule template for us and I can't seem to figure out how to round up the totals to the neares 10 (224.80 should be 230 and not be 1540 or 220). Tried the round up function, but it rounds up the individual lengths before calculating the totals, making the number way too big. Rounding in the field formating is not right either. Is there any way I can get this to work?

Revit_schedule_rounding.PNG

0 Likes
Reply
464 Views
6 Replies
Replies (6)

HVAC-Novice
Advisor
Advisor

I'm not sure what your calculated "Length10" parameter exactly does. Maybe show the equation. 

 

For that calculated parameter I would try to divide "Length" by 10, then round up, and then multiply by 10. 

Revit version: R2025.4
0 Likes

tamas_borsay2
Explorer
Explorer
Length10 should show the totaled pipe for given type and size, rounded up to the nearest 10m.
I tried the the 'roundup(Length/10000mm)*10000mm' (our project unit is mm). The issue is this rounds up all the pipes to the nearest 10m before the schedule totals up the length (I'm using the 'Calculate totals' from the Formatting page for 'Length10'). You can see this in the 'Length10' parameter, from 224m it goes up to 1540m. It should read 230m.
0 Likes

HVAC-Novice
Advisor
Advisor

Post a screenshot of the exact equation of that " Length10" parameter. 

 

So, the " Length" is the calculated total of all pipe segments of each size? 

 

If so, I would try to make that  "roundup(Length/10)*10" and make the units be meter, not mm. if that doesn't work and for some reason this rounds up each segment, maybe create an interim parameter " Length_Interim" =Length. Make sure that shows the same value as " Length". Then calculate the rounded total Length "roundup(Length_Interim/10)*10" and see if that works. 

 

if that works, just " hide" the initial and interim values. 

 

It would be nice if the rounding function had a way to enter a value to round to 10m, 100m etc. (like Excel does)

Revit version: R2025.4
0 Likes

ToanDN
Consultant
Consultant

Try this approach.  Revit 2024 file is attached for reference.

 

ToanDN_0-1723003373406.png

 

 

0 Likes

sgrdrafting
Explorer
Explorer

Go to your schedule, click on 'formatting' tab, click on the 'field', 'field formatting - filed format', round up settings in here.

0 Likes

halukuzuner
Advocate
Advocate

This setting may solve your problem.

halukuzuner_1-1738098732861.png

 

 

0 Likes