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:

[adamdavi3s]

Take a look here:

https://community.qlik.com/thread/124080?_ga=1.30768703.1846685376.1465898439

[oknotsen]

Maybe you can supply us with your QVW?

[anushree1]

Hi,

Check this

[chhavi376]

I am attaching a sample

[Anonymous]

Hi,

Round function should work on those cases.

But, since it is not working, try something like this:

=if(mid(YourNumber, index(YourNumber, '.') + 1, 1) >=5, ceil(YourNumber), floor(YourNumber) )

[swuehl · Accepted solution]

Maybe using a second round of integer values:

round(round(sum({<Flag={1}>} Value_N)*10),10)/10

Value_Type	=Date(Date,'MMM''YY')	Jul'16	Jun'16	May'16	Apr'16	Mar'16	Feb'16	Jan'16	Dec'15	Nov'15	Oct'15	Sep'15	Aug'15	Jul'15	Jun'15	May'15	Apr'15	Mar'15	Feb'15	Jan'15	Dec'14	Nov'14	Oct'14	Sep'14	Aug'14	Jul'14
Detail		16	18	17	27	27	35	24	18	11	12	3	2	18	28	29	24	18	19	39	37	40	33	26	11	2

[#8]

PFA

I think the below output you want to seems.

[chhavi376]

This works!

Thanks a lot !