Roundup routine

[kool_cons]

Hi,

Does anyone have a routine to ROUNDUP a number? I would appreciate your help.

[ArndW]

The INT() function will return 1 for 1.499 and 2 for 1.50001. Is this what you are looking for?

[kool_cons]

This is what i need..

ROUNDUP(31415.00, -2) Rounds 31415 up to 2 decimal places to the left of the decimal ((31500)..This is MS excel function,i am converting this formula in Datastage. Is there any other function which works as above.

.I guess int() can give 31415 only for this example.

[narasimha]

Try to explore FMT() function. You can do similar things using it.

[ArndW]

I would just use simple math; you can write your own roundup routine:

Roundup(Value,Places)

Code: Select all

   Shift = 10**Places
   Ans = INT(Value*Shift)/Shift

Hmmm, this could actually be an inline transform as well.

[ray.wurlod]

The INT() function is not what you want. The FIX() function will be close. Use 0 for the mode argument to get correct arithmetic rounding.

Code: Select all

FIX(number, precision, mode)

[kool_cons]

Thanks i am have written a small routine with Int. this is working fine.

[ray.wurlod]

I'm surprised. On my system Int(1.50001) returned 1. This does not accord with the original requirement. Int() returns the largest integer smaller than the argument.