>>>Yes, it seems to be global. Also for some reason the NULLDISPLAY property I set for textboxes in the grids columns are ignored. And also
>>>
>>>I have
sum nI_Dept, nH_Dept, nM_Dept, nO_Dept, nTotal to lnI, lnH, lnM, lnO, lnTotal
>>>
>>>where all nI_dept are null. But the sum value is 0.00 Why is that?
>>
>>I think null values are automatically converted to zero for the SUM command,
>
>not true, null values are ignored, but the result start with 0.
>
>> and for the SQL SELECT SUM() function.
>
>not true, null values are ignored, but the result start with null.
>
>This is important for AVG() computation.
>
>> I don't know about an easy workaround, in case you want to have the sum = NULL (in case one or more of the elements is NULL - this might indicate that data is missing).
>
>not possible.
Well, I guess instead of SUM you can use SCAN /ENDSCAN In my case I just can safely assume that 0 = NULL.
If it's not broken, fix it until it is.
My Blog