Virtual Fields that round up

I need to create a virtual field within a custom list that rounds up to the next highest integer in case of a fractional amount... anyone had luck with such a requirement?

If my base value is 1, I need to report 1. If it's 1.1, I need to show 2, and if it's 1.9 I need to show 2.

By default, the calculation process rounds to the nearest integer, so 1.1 shows as 1.

Find more posts tagged with

Accepted answers

Legacy Contributor

Hi Dirk,

You can probably make some new virtual fields and do the rounding yourself:

One field with the rounded value (VF1)
One field with the rounded value + 1 (VF2)
One field with the difference between field value (F) and rounded value (VF1) (F-VF1 = VF3)
If VF3<0 you use VF1, else VF2

All comments

Legacy Contributor

I checked and it is possible to have decimal places as 0 in cms012.for that virtual field. And that updated correctly . For example , the value of 9.16 to 9 and 9.8 to 10 .

Legacy Contributor

I'm afraid that is not what I am looking for. I want any fraction to be rounded up in this case, so 9.16 should show as 10 (this is to reflect how many pallets will be needed for various inventory balances).

Legacy Contributor

Hi Dirk,

You can probably make some new virtual fields and do the rounding yourself:

One field with the rounded value (VF1)
One field with the rounded value + 1 (VF2)
One field with the difference between field value (F) and rounded value (VF1) (F-VF1 = VF3)
If VF3<0 you use VF1, else VF2

Legacy Contributor

I was trying to come up with something similar but couldn't get it quite right, that looks like it would work. Thanks Fons!

Copyright © 2025 Infor. All rights reserved.