Hi All,
We are trying to run sum on a column of a table.
select sum(nvl(GROSS_SALES_PRODUCT_QUANTITY,0)) from dsstrd where calendar_number=2459573 ;
Its giving result: 795847
select sum(GROSS_SALES_PRODUCT_QUANTITY) from dsstrd where calendar_number=2459573 ;
Its giving result-- 506813
There is no null value on GROSS_SALES_PRODUCT_QUANTITY in table . Could you please suggest what could be the issue?
Appreciate your help on this. Thank you!!