Qliksense Ceil and Floor not picking the fractions in where clause

[K7pramod]

Hi,

I am using Floor() and Ceil() functions to get the rows in between 2 values, but when the value of PercentileMark95 is in fractions the below condition is not working good.

where RowNum >= Floor(PercentileMark95) and RowNum <= Ceil(PercentileMark95)
this is returning Ture only when there is full INT value in it.
Is there any solution for this problem, this is used in Loading data.

[K7pramod · Accepted solution]

Found the issue - the problem was not in Floor() and Ceil(), i was using mod() in place fmod(). fmod() worked fine.