>I am using FPW26. I am trying to UNION two select statement. The SELECT statement looks like the following:
>
>SELECT a.doc_no, doc_date, SUM(apply+discount+miscellaneous) AS problem;
> from a, b ;
> where a,doc=b.doc ;
>UNION ;
>SELECT a.doc, doc_date, doc_amt ;
> from a ;
> where .......
>
>
>Anybody can tell me how I can force the SUM() type to be the Numeric size I want. apply is N(9,2). discount is N(7,2), miscellaneous is N(7,2), problem ended up as N(16,2) and my doc_amt is N(9,2). How to force problem to be N(9,2)?
>
>
>Tai SC
You are so right this silly behaviour. A silly but working suggestion is here :
SELECT a.doc_no, doc_date, SUM(apply+discount+miscellaneous) * 1000000.00/1000000.00 AS problem;
from a, b ;
where a,doc=b.doc ;
UNION ;
SELECT a.doc, doc_date, doc_amt* 1000000.00/1000000.00 ;
from a ;
where .......
Cetin