topic Re: Basic mathematics gives wrong result in QlikView

Basic mathematics gives wrong result

Sun, 25 Jun 2017 02:28:47 GMT

can you try this in Qlikview text box and see what result you get. =If((2700/600000)*100<0.45,1)

I get 1, tried multiple versions.

Re: Basic mathematics gives wrong result

Anil_Babu_Samineni — Sun, 25 Jun 2017 05:56:36 GMT

Because, We don't know whether how many decimals we get after that calculation. I know 1 is wrong in your case. Try some thing like below

=If((2700/600000)*100<0.45,1, 0)

I assume, this will return 1 because as i mentioned before line we are not understand the decimal point

=If(Ceil(2700/600000)*100<0.45,1, 0)

I assume, The calculation part is wrong it should return 0, Because now ceil() function can understand the decimal points where we are using calculation of %. If this condition returns 0 then the condition true

If you want, More information he will offer you better than me marcus_sommer‌

Meantime, go to help and check Round() and Ceil() functions to understand.

HTH

Anil

Re: Basic mathematics gives wrong result

swuehl — Sun, 25 Jun 2017 07:04:46 GMT

Have a look at

Rounding Errors

In your case, you could try to multiply both sides of the equation with 100 and maybe add round to the left side (assuming that the numbers are not fixed, but part of e.g. an aggregation and right side is a constant threshold) to overcome this issue:

=((2700/600000)*100)*100 < 45

=Round(YourCalculation*100) < 45