topic Re: ROUNDUP, without ROUND in QlikView

ROUNDUP, without ROUND

Wed, 22 Apr 2015 00:20:00 GMT

ROUNDUP, without ROUND

Best regards

I wish rounding the result to the maximum without ROUND, since it makes if the decimal is 5 or above is rounded, otherwise it does not. Example: round (2.4) returns 2; round (2.6 returns 3), but I need you round all, example: XX (2.2) = 3; XX (2.5) = 3. something similar to excel, when used "roundup"

I would appreciate your valuable assistance

thank you very much

Re: ROUNDUP, without ROUND

jonathandienst — Wed, 22 Apr 2015 07:12:38 GMT

Use the CEIL() function in the same way as round - always "rounds" up.

HTH

Jonathan

Re: ROUNDUP, without ROUND

Agis-Kalogiannis — Wed, 22 Apr 2015 09:31:52 GMT

Yeap. ceil() function will do exactly what you want and floor() will do exactly the opposite. 🙂

Agis

Re: ROUNDUP, without ROUND

buzzy996 — Wed, 22 Apr 2015 09:38:34 GMT

from reference manual,

ceil( x [ , base [ , offset ]] )

Rounding of x upwards to the nearest multiple of base with an offset

of offset. The result is a number.

Examples:

ceil( 2.4 ) returns 3

ceil( 2.6 ) returns 3

ceil( 3.88 , 0.1 ) returns 3.9

ceil( 3.88 , 5 ) returns 5

ceil( 1.1 , 1 , 0.5 ) returns 1.5

Re: ROUNDUP, without ROUND

Wed, 22 Apr 2015 16:33:12 GMT

I would appreciate your help it works perfect

Re: ROUNDUP, without ROUND

buzzy996 — Wed, 22 Apr 2015 16:34:41 GMT

ur wc,if u are happy with tht..pls mark as correct.

Re: ROUNDUP, without ROUND

oknotsen — Wed, 22 Apr 2015 21:32:57 GMT

If your questions is answered, please flag the correct answer so the topic is flagged as answered. Thank you.