Rounding a summary field

[indy4300]

 (Building Height *12 - Pallet Height ) / ( Pallet Height+ 3)
(10' x 12 = 120 - 57" = 63" ) /  ( 57 + 3 = 60" ) = 1.05
I need to round this to 1

 

[doughemi]

If you need to always round down, wrap the Floor( ) function around your calculation. 

If you need to always round up, use the Ceiling( ) function.

If you need to round normally (under 5 down, over 5 up), use the Round ( ) function with a precision of 0 [e.g.  Round( (Building Height *12 - Pallet Height ) / ( Pallet Height+ 3); 0) ]

[indy4300]

Thank you so much worked great