Adam Kucharski
New Member
Big error:
MFG/PRO on Linux
SQL Explorer:
select ac_code,
SUM(case when acd_year < 2006 then acd_amt else 0.0000001 end)
from .....
rounds to INTEGER,
but when
select ac_code,
SUM(acd_amt)
from .....
result is good (NUMERIC (25,10))
Any ASAP help from PROGRESS support Team ??
Adam
MFG/PRO on Linux
SQL Explorer:
select ac_code,
SUM(case when acd_year < 2006 then acd_amt else 0.0000001 end)
from .....
rounds to INTEGER,
but when
select ac_code,
SUM(acd_amt)
from .....
result is good (NUMERIC (25,10))
Any ASAP help from PROGRESS support Team ??
Adam