Commented by: Sean Leyne (seanleyne)

You haven't said specifically what the expected results should be for a given condition.

Further, although the database will be appreciated, should it be needed, you need to provide specific details to reproduce, the current details are not enough for that purpose.

It seems that you believe that if a REM.{field} is NULL that the results should have a non-NULL value, you are mistaken. SQL defines very specific rules for the handling of NULLs.

Commented by: @hvlad

I understand nothing. Please provide DDL, some data and expected results.

Commented by: Dmitry Lendel (dmitryle)

Test database is here http://www.bagel.com.ua/download/testdata.zip
Run Query
Select Sum(FF.F2*FF.Quantity)
From (
select
Rem.iddepot,
Rem.idcommodity,
case :qq1
when 1 then Rem.costprice
else null end as f1,
case :qq2
when 1 then Rem.saleprice
else null end as f2,
case :qq3
when 1 then Rem.usebydate
else null end as f3,
case :qq4
when 1 then Rem.idcolor
else null end as f4,
case :qq5
when 1 then Rem.barcode
else null end as f5,
case :qq6
when 1 then Rem.param1
else null end as f6,
case :qq7
when 1 then Rem.param2
else null end as f7,
Sum(Rem.QUANTITY) as Quantity
from remainder Rem
where IDDate<=:LIDDate
group by 1,2,3,4,5,6,7,8,9
having Sum(Rem.QUANTITY)>0
) AS FF

with params qq1 = 1 qq2=2 qq3 is null qq4 is null qq5 is null qq6 is null qq7 is null LIDDate=current_date
Result 137499.705249999999

with params qq1 = 1 qq2=2 qq3=1 qq4=1 qq5 is null qq6 is null qq7 is null LIDDate=current_date
Result 137668.580249999999

Commented by: Dmitry Lendel (dmitryle)

Select Sum(SalePrice*Quantity) from Remainder
Result 137499.705249999999

Commented by: Dmitry Lendel (dmitryle)

I am sorry. I found my mistake. Thank you.