I'm really confused about Floor() function
why Floor(3.51,-0.5) returns 4.0 ?
why Floor(3.51,-0.9) returns 3.6 ?
how it works ,plz explain in calculation detail , thx
Draw a little picture for you:
the negative value of the base in Floor() function returns the nearest right value
View solution in original post
Please check this
Doubts in understanding the ceil and floor func... | Qlik Community
Floor ‒ QlikView
Can I come to this conclusion ?
Floor(a,-b) = Ceil(a,b)
Ceil(a,-b) = Floor(a,b) ?
Yes, (at least I tried different examples) and it seems to be that your conclusion is correct 😃
Magic of rounding =D
Brilliant ! thanks a lot Sergey
Thank you so much!