Expression (round )

[#1]

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

[sunny_talwar]

Are you rounding to two decimals?

Round(A, 0.01)

[Chanty4u]

check this

Rounding Errors

[agomes1971]

Hi,

what about reading this

Re: Doubts in understanding the ceil and floor functions

HTH

André Gomes

[ToniKautto]

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

[#6]

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.

[sunny_talwar · Accepted solution]

Try this:

=Round(7074, 10)