Correcting the Decimal Value in script

[#1]

Hi,

I am loading data from two different tables but amount value are not matching after decimals for same documents ,I want to match these table and eliminate duplicate. Since Amount flied are not same I am unable identify duplicates .Can anyone help to correct Decimals values.

I have tried Num(Num#( '[Amount ]'),'#,###.##')) and Num(Num#( '[Amount in LC_DMBTR]'),'#,###.00')) but its not working

Table 1

Doc	Amount
1	900.00
2	1000.5
3	100.55
4	200

Table 2

Doc	Amount
1	900
2	1000.50
3	100.55
4	200.00

[swuehl]

Just using

Set DecimalSep = '.';

T

able1:

LOAD * INLINE [

Doc,    Amount

1,    900.00

2,    1000.5

3,    100.55

4,    200

];

LOAD * INLINE [

Doc,    Amount

1,    900

2,    1000.50

3,    100.55

4    ,200.00

];

resulted in matching records in my setting.

But matching floating point values is not a trivial task. You may want to consider using round() or something like this (floor(), ceil() etc.) to define a common number base.

[#3]

Its not working ,I have tried floor(), ceil() also