Rounding off to an integer using NUM

[chhavi376]

I was trying to round off all my numbers to integer but i came across this problem:

if i use '#,##0.00'  in num, i get these numbers:

When we round this off, it should ideally be 16, 27 and 35

But when i use '#,##0'  in num, i get these numbers:

[sunny_talwar]

Look here for Rounding error issues in QlikView:

Rounding Errors

[Nicole-Smith]

Is 15.50 rounded?  If the underlying data is actually something like 15.4991, rounded to two decimal places, it would be 15.50, but the rounded integer would be 15 instead of 16.

You could also try using round() instead of num() to get the integer value.

[chhavi376]

Hi Nicole,

I just checked the data in my reporting tables,

It is exact '15.5'

the round function also gives me 15, if i use '1'as the offset.

[#5]

Hey please Round()  and dont use num() inside for that

i hope it will work

[saimahasan]

Hi

Please use ceil function:

Ceil(FieldName) as FieldName

[Anil_Babu_Samineni]

O/P for this

LOAD Floor(Round(Value)-1) as Value INLINE [

Value

12.6

13.8

14.5

];

Value

12

13

14

[gautik92]

use round()

[chhavi376]

Vijay,

As per my understanding, floor() function rounds the numbers down.

i want it to round as per the logic:

number >= x.5 gives me x+1

and number <x.5 gives me x.

and as i mentioned in the original post,

my numbers from the reporting tables were 15.5, 26.5 and 34.5

but when i round them, i get 15,27 and 35

So why is 15.5 not rounding upto 16?

I have tried using num(), round(), ceil() and now floor() as well.

But i get the same numbers-15,27,35, which are not correct

[chhavi376]

Round(), Ceil(), Floor(), Num()- doesn't work!