Round value up to next highest integer

[Former Member]

Hi,

I have a formula and I would like the result to round up to the next highest integer. I am currently using the Round function and it of course rounds down until it gets to .5 or higher. Any help would be appreciated. Thanks.

[Former Member · Accepted solution]

something along the lines of:

Round ( {fieldname}+ .499999 )

regards,

dom

[Former Member · Accepted solution]

Thanks. Simple and effective.

[Former Member]

or:

If {fieldname} - truncate({fieldname}) <> 0 then 
    truncate({fieldname}) + 1 
else 
    {fieldname}

[Former Member]

Hi David,

Place the formula in your report and right click on the field and go in Format FieldSelect Number Tabselect Customize then select Decimal value as 1

Thanks,

Sastry