topic Re: Round from 3 to 2 digits in QlikView

Round from 3 to 2 digits

jaimeeduardo_gc — Thu, 21 Jun 2018 05:54:29 GMT

Hi everyone,

I need to round all my expressions from 3 digits to 2 digits, but having this consideration:

IF the last digit is <= 5 then round down.

For example:

3.715 -> 3.71

6.453 -> 6.45

Else if the last digit is > 5 then rown up

3.716 ->3.72

1.347 -> 1.35

I will appreciate all the suggestions.

Thanks for helping me!!

joseph_eftamand — Thu, 21 Jun 2018 07:03:28 GMT

Have you tried the round function?

For example =round(0.856,0.01) will output 0.86, while =round(0.853,0.01) will output 0.85.

To get the functionality where x <= 5 rounds down you could just use a conditional statement for example:

if(mid($(a),5,1) ='5',round($(a),0.01) - 0.01,round($(a),0.01))

where a = 0.845 you will find you get the right result.

Hope it helps.

sunny_talwar — Thu, 21 Jun 2018 11:34:20 GMT

How about this

=Round(Number-0.000000000001, 0.01)

or even this

=Round(Number-0.001, 0.01)