See mskb #133001 and Re: Invalid Subscript Reference Error Message #990684

>
>Thank you very much for your help. Your suggestion works. I just need to figure out why.
>
>>Make 0 constant the same size/format as the fields.

>>nvl(SUM(CHILD1.NUM_FIELD1),000000000000.00) AS TOT_NUM1, ;
>>nvl(SUM(CHILD2.NUM_FIELD2*CHILD2.NUM_FIELD3),000000000000.00) as TOT_NUM2, ;	
>>

>>