topic Re: Floor Function Inconsistent in QlikView

Floor Function Inconsistent

wcilliers — Tue, 08 Nov 2016 12:53:52 GMT

Hi Experts,

Can someone please help explaining to me. We have a need to ROUND DOWN to two decimals and the only way I believe is by using the FLOOR functions. However, it seems to be inconsistent. As you can see below, on some of them it actually drops down 1 decimal. In this case it should not change any of these numbers, or am I missing something here?

Thanks,

Wynand

Re: Floor Function Inconsistent

awhitfield — Tue, 08 Nov 2016 16:11:40 GMT

Use round instead

Re: Floor Function Inconsistent

sunny_talwar — Tue, 08 Nov 2016 17:24:27 GMT

Something to read:

Rounding Errors

Re: Floor Function Inconsistent

wcilliers — Wed, 09 Nov 2016 07:56:46 GMT

I cannot use round, I have to ROUND DOWN. So 1.678 becomes 1.67 and NOT 1.68. This is just example data, and I found some inconsistencies in my actual data and started testing, that is why I posted here.

Re: Floor Function Inconsistent

wcilliers — Wed, 09 Nov 2016 11:41:37 GMT

Thanks Sunny,

This is very interesting. I will have a look at some of the workarounds.

Thanks,

Wynand