Floor Function

[#1]

Hi, I have a question about Floor Function. Could someone explain how Floor(3.5,-0.5) results in 4.0? I was thinking that it would result in 3.0

Any help will be greatly appreciated

[Clever_Anjos]

Into version 12 returns 3.5 that is consistent since you are passing a "step" parameter 0.5

If you want to floor to next integer use Floor(3.5)

[Chanty4u]

chk dis too

Try  = Floor(3.5)

Rounding Errors

[jonathandienst]

Floor Rounds down to the nearest multiple of the second parameter (to the precision of the second parameter).

Floor(3.6) -- > 3

Floor(3.6, 0.5) -- > 3.5

Floor(3.6, 0.1) --  > 3.6

(In all versions of QV that I have used)

[#5]

Hi,

Refer to the following link :

Floor Function Details

Regards,

Snehal Nabar

[jharke]

Hello Rahul,

You use a Floor function (= kind of rounding down) with a minus-sign after the comma, that means that it is rounding up.

As a matter of fact, you use kind of Ceil(3.5,0.5).

(If you delete the minus sign, I think the result wil be 3.5)

(I wonder why the result of Floor(3.5,-0.5) would be 4. maybe 3.5 is a bit more, e.g. 3.5000001?)

[Anonymous]

why we using Floor Function?

[Clever_Anjos]

I think floor is the topic, right?

[Anonymous]

sure, floor is topic but which type of scenario can be use?

[Clever_Anjos]

Several cases:

1. You have a frac number 4.678 for example and want to round to smallest 4
2. You have a frac number 4.678 for example and want to round to smallest 4.6
3. You have a datetime field and want to extract the date part   Date(Floor(yourfield))