topic rounding downward in round() in QlikView

rounding downward in round()

Tue, 12 Apr 2011 14:29:17 GMT

Hello all im new in QV.

im using round() to round up or down numbers. but now i need to round down number ending with .005
In QV help it says "If x is exactly in the middle of an interval, it is rounded upwards" Is it possible to do it in round(). Or should i use floor()?

rounding downward in round()

Tue, 12 Apr 2011 14:57:43 GMT

You can try

=round(0.005,-0.01)

That gives 0.00

=round(0.005,0.01)

That gives 0.01

Regards

Anders

rounding downward in round()

IAMDV — Tue, 12 Apr 2011 15:02:29 GMT

Rounding Upwards

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

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

ceil( 2.4 ) returns 3

Rounding Downwards

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

Rounding of x downwards to the nearest multiple of base with an
offset of offset.

floor( 2.4 ) returns 2

I hope this helps.. Please mark the post answered if this helps!

rounding downward in round()

Tue, 12 Apr 2011 15:12:56 GMT

thanks everyone. Specially Ansch. Your solution working perfect ^^

Re: rounding downward in round()

arngue — Fri, 04 Jan 2019 10:19:18 GMT

This won't round down, just will omit the 3rd decimal value and in this case the result is a rownddown but if you wanna to rownddown without decimals won't work, yo'll had to do other thing.

Re: rounding downward in round()

deepikashinde — Mon, 25 Mar 2019 12:21:22 GMT

Hi,

what if we want round value less if value is x.5 and greater than x.5 then upper value

e.g:

Value is 2.5 should return 2

Value is 2.6 should return 3