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?
I'm afraid i don't have SAP B1 open, but you could try adding a formula field which is your database field + 0.5
Then you could round up the formula field from above to no decimal points?
0.25 + 0.5 = 0.75 (rounded to 1).
0.75 + 0.5 = 1.25 (rounded to 1).
Let me know if this does not work as there may be a different way of doing it.