Ceil() and Floor() Functions doing Opposite rounding

[canerkan]

Hi Everyone,

This might end up as a stupid question but i need to know.. we are currently using August 2022 Patch 1 Qlik Sense Enterprise Version. I noticed, that the Ceil() Functions is rounding down and the Floor() Function is rounding up, so the opposite way of how it is supposed to be. Did someone else notice this behaviour as well? Could that be a bug or am I doing something wrong?

Thanks,

Can

[marcus_sommer]

It shouldn't happens. Are the values positive or negative or did you check it definitely against all types by avoiding all possible formatting- and/or dual() stuff?

- Marcus

[canerkan]

Nevermind i used the wrong decimal separators in the formula editor in my examples.

And i guess in my real data there must be something wrong in the way i am calculating it in the load script.