How to round the value UP 1

[OLTU]

Hi ,

Using version crystal 8.5.

Need help to round up the values like below,

0.2 should be 1
0.5 should be 1
0.8 should be 1
1.1 should be 2
1.9 should be 2
2.1 should be 3 etc.

thx

 

[lupins46]

Can't remember what functions are available in v8.5.

Do you have:

RoundUp({mytable.myvalue})

Ceiling({mytable.myvalue}) (for +ve nos)

If not then fix({mytable.myvalue}+ 0.999) (for +ve nos)

 

[lbass]

Try:

-int(-{table.amt})

-LB

 

[OLTU]

Ibass,

What dou you exactly mean with
-int(-{table.amt})?

I want to roundup my @formula records.

Thx

 

[lbass]

Create a formula:

-int(-{@yourformula})

-LB

 

[OLTU]

it works perfect !!!

thx