round ?

[#1]

Hello,

i want to have a dynamic dimension

that rounds an existing dimension at one position after the decimal point.

Is the "QV round function" working similar to the "excel round function"?

greetings

daniel

[swuehl · Accepted solution]

Well, both functions round so I guess they are similar...

There are differences though, QV rounds takes a base as second parameter, so if you want to round to one decimal point, you need something like

=round(Value, 0.1)

where AFAIR Excel uses ROUND(CELL; 1)

Does this answer your question?

[#3]

thanks for your quick help

you 're right excel is using the round function   Round (A1; 1)

so long

daniel

[kamalqlik]

HI Daniel ....in qlikview....for rounding we use the round()....go in the help tab..

and there are other functions such as ceil and floor...which are used for get tghe value