rounding of a pipes length sum in report creator

[mcray100500]

Hello!

I have a report for counting lengths of the pipes. Pipes are grouped according to DN. The values of the lengths of the grouped pipes is rounded to three decimal places and looks like this: 0.108; 4.599; 71.285.

Now I need to round this values up to a larger whole, in other word, looks like this: 1; 5; 72.

Is there a way to do this?

Thanks in advance!

[KenFauver]

You will need to create a new expression for this to work. If you haven't figured this out yet attach the report to this post and I'll take a look at it.

[jdelucaQF5BX]

I would like to round piping lengths UP to a whole number (i.e. 9.3 goes to 10).  I tried the Ceiling expression, but it seems inconsistent.  It rounded 0.5 to 2, 9.52 to 13, 15.8 to 17, etc.  However, there was one place where it perfomed as I expected and rounded 13.8 to 14.  Is this the right expression to use?  If so, is there a way to make it more accurate?  The complete expression for "Quantity" in my BOM Report is pasted below.  (The division by 12 is to have the output in feet instead of inches.  I also have an expression to output the number of bolts instead of bolt sets)

Iif(IsNullOrEmpty([BoltSet_NumberInSet]),Iif(IsNullOrEmpty([Pipe_CutLength]), 1,Ceiling([Pipe_CutLength]/12)),[BoltSet_NumberInSet])