topic Re: Easy Division in Script in QlikView

Easy Division in Script

Mon, 13 Oct 2014 12:29:16 GMT

Hi,

I have the script that follows:

SET ThousandSep='.';
SET DecimalSep=',';

LET vNum= num(83.16);

LOAD
num($(vNum),'#.##0,00')/4 as number
AUTOGENERATE(1);

I got in number 20,75. But I should get 20,79!

Does anyone knows whats wrong?

Thanks!

chematos — Mon, 13 Oct 2014 12:59:10 GMT

Try this:

LET vNum= num#(83.16, '#.##0,00');

LOAD

num#(($(vNum)/4),'#.##0,00') as number

AUTOGENERATE(1);

vNum was being rounded to 83, that was happening.

Regards,

Jose

Mon, 13 Oct 2014 13:07:51 GMT

Thanks!

That small difference between num() and num#() its what I need.