This content has been marked as final.
Show 3 replies
-
round ?
Stefan Wühl Oct 19, 2011 10:20 AM (in response to daniel_k)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?
-
round ?
daniel_k Oct 19, 2011 10:23 AM (in response to daniel_k)thanks for your quick help
you 're right excel is using the round function Round (A1; 1)
so long
daniel
-
round ?
Kamal Naithani Oct 20, 2011 5:55 AM (in response to daniel_k)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
-