topic Help for about decimal. in QlikView

Help for about decimal.

Tue, 18 Aug 2009 15:49:50 GMT

Hello,

In Pivot table , Expression i used the num( ) function. The function is show the decimal place is correct but when the formula was manipulated they used the original value. That mean

i used the function like that,

num('0.32409178531','.##') * num('40648.216','.##') => 13173.752893

I checked each function's output is correct , num('0.32409178531','.##') output is => 0.32

num('40648.216','.##') output is => 40648.22

but combine these functions together

num('0.32409178531','.##') * num('40648.216','.##') output=> 13173.752893

The answer should be, 13007.

Can anybody help me? Thanks a lot for advance.

Help for about decimal.

Tue, 18 Aug 2009 16:29:31 GMT

I think they taken 0.32 instead of 0.32409178531

floor(num('0.32','.##') * num('40648.216','.##')) . This will give you the exact value 13007

-Raghu

Help for about decimal.

Tue, 18 Aug 2009 16:45:33 GMT

Hi Raghu,

But , i don't want to change the the value '0.32409178531' to '0.32'.

Because in the report the value may not be the fix.

Do you have any other way to do that.

Thanks a lot.

Help for about decimal.

Tue, 18 Aug 2009 17:05:14 GMT

Take first two decimal places using functions and multiply with the number.

I think the only reason the value get changed because of '0.32409178531'. If you take only the first two decimal places then the answer will be correct.

-Raghu.

Help for about decimal.

Tue, 18 Aug 2009 17:45:02 GMT

Hello,

Can you try that :

=round(num('0.32409178531','.##'),0.01) * round(num('40648.216','.##'),0.01)

Help for about decimal.

Tue, 18 Aug 2009 18:12:38 GMT

yeah philippe, your expression will give the answer.

we can use the floor function to get the numeric part.

=Floor(=round(num('0.32409178531','.##'),0.01) * round(num('40648.216','.##'),0.01))

-Raghu

Help for about decimal.

Wed, 19 Aug 2009 07:38:37 GMT

Hi Raghu and Philippe,

Thanks you very much.

Your function is work. Thanks a lot.