https://community.qlik.com/t5/Search-the-Community/Ceil/m-p/1845766#M626 <P>How does the ceil and floor functions work on negative scale I meant to say if step interval is negative&nbsp;</P><P>Ex:(1.1,-2)</P> Tue, 12 Oct 2021 17:59:31 GMT Rahul6 2021-10-12T17:59:31Z https://community.qlik.com/t5/Search-the-Community/Ceil/m-p/1845766#M626 <P>How does the ceil and floor functions work on negative scale I meant to say if step interval is negative&nbsp;</P><P>Ex:(1.1,-2)</P> Tue, 12 Oct 2021 17:59:31 GMT https://community.qlik.com/t5/Search-the-Community/Ceil/m-p/1845766#M626 Rahul6 2021-10-12T17:59:31Z https://community.qlik.com/t5/Search-the-Community/Ceil/m-p/1845779#M627 <P>Should be identical to Floor(1.1,2), I believe. Not sure why you'd want to do that, though.</P> Tue, 12 Oct 2021 18:18:58 GMT https://community.qlik.com/t5/Search-the-Community/Ceil/m-p/1845779#M627 Or 2021-10-12T18:18:58Z https://community.qlik.com/t5/Search-the-Community/Ceil/m-p/1845785#M628 <P>Agree with&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6142">@Or</a>&nbsp;.&nbsp; -step in ceil = +step in floor and vice versa.</P> Tue, 12 Oct 2021 18:42:20 GMT https://community.qlik.com/t5/Search-the-Community/Ceil/m-p/1845785#M628 stevejoyce 2021-10-12T18:42:20Z https://community.qlik.com/t5/Search-the-Community/Ceil/m-p/1845813#M629 <P><SPAN>I was already getting the results as you explained before I posted this query ...even I made my own perception that in limits if&nbsp; the value is negative the lower and upper values are will be in contrast with the upper and lower values of the&nbsp; positive ones ...so I thought ceil and floor are interchanging their roles when it comes to negative step interval ....but before concluding it to myself I wanted Someone to spare their opinions ..so thank you guys for your help&nbsp;</SPAN></P> Tue, 12 Oct 2021 20:50:34 GMT https://community.qlik.com/t5/Search-the-Community/Ceil/m-p/1845813#M629 Rahul6 2021-10-12T20:50:34Z