Return worng value in the formated search.

[Former Member]

i m use formated search on the purchase document.

SELECT($[POR1.U_PurchaseTotal.number]/$[$38.11.number])

select(5/10)

return 0, why ?

And if(10/5)

return 2(Correct)

[Former Member]

Please modify:

Declare @Var1 Decimal(11,6)

Declare @Var2 Decimal(10,6)

Declare @Var3 Decimal(16,6)

set @Var1 = 10000.000

set @Var2 = 100.000000

set @Var3 = (@Var2/@Var1)

select @Var3

[Former Member]

sq

[Former Member]

Because this FMS result round off to the integer that might be smaller than the actual result.

Thanks,

Gordon

[Former Member]

hi,

how to solve this problem.

when we are dividing 100/1000 it is giving results but when dividing 100/100000 it is giving error:"airthmatic overflow"

how to solve this....

we using following query and using formated search

Declare @Var1 Decimal(10,6)

Declare @Var2 Decimal(10,6)

Declare @Var3 Decimal(16,6)

set @Var1 = 10000.000

set @Var2 = 100.000000

set @Var3 = (@Var2/@Var1)

select(@Var3)

Thanks

Neetu.