Query Calculated Field - Round Up

Epicor ERP 9
1

How can I get a calculated display field to RoundUp in the BAQ I am building? Seems to be not so simple…

2

Round down after adding 0.499999 to the value being rounded

Round(10.0+0.4999999) -> 10
Round(10.1+0.4999999) -> 11
Round(10.9+0.4999999) -> 11

Note that this rounds “up” as in a larger value
Round(-10.0+0.4999999) -> -10
Round(-10.1+0.4999999) -> -10
Round(-10.9+0.4999999) -> -10

3

Thank you Calvin, what do I enter in the editor area?

4 
round(decimalFieldToBeRounded + 0.49999, 0)

Make sure the calc field type is Int

Edit: cal field does not have to be int.

5

Thank you Calvin, works perfectly!!! Guess I was over complicating it…

6

While not explicitly listed in the functions in the Calc Field Editor,

ceiling(yourValue); does the same.
1 Like
7

Thank you for this little hint!! Exactly what I needed.