Division Issues

[#1]

Hello Everybody,

I am facing issue in division and decimal values.

In a text file I tried
=(-3948.41/-39484.08)*100 and the result is 10.000005065333

But if you try the samething manually in calculator you will get the result 10.0000050653327

The thing is QlikView is rounding off the last two values i.e 27 to 3.

Could any one please tell me how to get the correct value if we calculate it mannually  .

Thanks In Advance

Sonali

Message was edited by: Sonali Singh

[marcus_malinow]

use the num function to round to as many decimals as you require

e.g.

num(

(-3948.41/-39484.08)*100

,'#.000000000000000')

[#3]

HI Sonali,

If it is in dash borad you need to check the property called Sort in that you can change how many decimals you need.

[marcus_malinow]

n.b with 15 dp, as in my example above, you'll get a result of 10.000005065332660

[#5]

Ya correct I think Num function works upto 14 decimal places.

I tried the same  upto 14 decimals =num((-3948.41/-39484.08)*100,'#,##0.00000000000000') and got 10.00000506533266

and if you give 15 decimals =num((-3948.41/-39484.08)*100,'#,##0.000000000000000') gives 10.000005065332660 but what I want is 10.0000050653327

[marwen_garwachi · Accepted solution]

Try this :

=num(((-3948.41/-39484.08)*100),'############ ###')

Ps: you can also put this format (############ ###) in Numbers format panel.

Hope it will help you.

Marwen

[#7]

Thank you very much... It's working

[marcus_malinow]

So try to 13 decimals

You're welcome

[#9]

HI Marwen,

still some issue is there.

If I am trying  =num((546.42/1787.66)*100,'###############') in text object I am getting the result 30.5662150520793 but if I am using the same thing in the script I am getting the result as 30.566215052079.

The same Num function works differently in script and in text object.

What I want is if I apply the same thing in script and load this then also the result should be 30.5662150520793.

Please advice.

[marwen_garwachi]

can you publich a sample file ?

Regards

Marwen