# Rounding a summary field

This topic is 2221 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

(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

##### Share on other sites

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) ]

##### Share on other sites

Thank you so much worked great

##### Share on other sites

This topic is 2221 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account

• ### Similar Content

• #### fmp17 How to force calculation in layout to round to two decimals

By BAleiHi,

• 4 replies
• 1,649 views
• #### Formula to convert .6666666 to be displayed as 2/3?

By ltoth,

• 2 replies
• 2,027 views
×
×
• Create New...