Skip to Content
Former Member
Mar 02, 2009 at 01:36 PM

Rounding up values in Print Layout Designer


The customer has a database field in print layout designer and this is bringing back a value such as 0.25. They would like to create another field which shows this value rounded up to the nearest whole number, ie in the case of 0.25 they would like to see 1.

They have created a formulae field and used the round function, however this rounds the value down to the nearest whole number as per the general rounding rule i.e. round it down if it is below .5 and up to the nearest whole number when it is above .5

Is there anyway to achieve this using Print Layout Designer in SAP Business One 2007 A?