topic Re: Expression (round ) in QlikView

Expression (round )

Wed, 25 Nov 2020 16:16:04 GMT

Dear Experts,

my simple expression is as follows,

ROUND(A,2)

A= my first expression.

rounding function not works as expected. (the result is as same in the first expression)

Can any one help me??

Rgds,

Priyantha

Re: Expression (round )

sunny_talwar — Wed, 31 Aug 2016 10:33:39 GMT

Are you rounding to two decimals?

Round(A, 0.01)

Re: Expression (round )

Chanty4u — Wed, 31 Aug 2016 10:35:17 GMT

check this

Rounding Errors

Re: Expression (round )

agomes1971 — Wed, 31 Aug 2016 10:40:24 GMT

Hi,

what about reading this

Re: Doubts in understanding the ceil and floor functions

HTH

André Gomes

Re: Expression (round )

ToniKautto — Wed, 31 Aug 2016 10:42:05 GMT

Since A is a letter and can not be rounded, it is hard to tell from your example what exactly you are observing. Can you please provide the numerical example that does not work as expected? I would also recommend that you look at the function definition in the help, so that your expectations are accurate.

Round ‒ QlikView

Re: Expression (round )

Wed, 31 Aug 2016 10:54:13 GMT

Hi Tony,

My expression is as follows

pmt(0.3405/12,8,-50,000,0,0)

the result of the expression = 7074

I want to have the answer =7070

so what i did is round(pmt(0.3405/12,8,-50,000,0,0),1)

but result is same.

rgds,

Priyantha.

Re: Expression (round )

sunny_talwar — Wed, 31 Aug 2016 10:58:01 GMT

Try this:

=Round(7074, 10)