Only show one row per product

[Simon4]

Dear all,

I am making a saleslist. Right now I am trying to add the amount of a product that is in production and the finishing date. when I do this a extra row pops up. How do I avoid this?

Result without production info

Result with production info

I am using these formula's

this one for the quantity in production

=if(isnull(DATEPRODUCTIONFINISHED), ORIGINALSUBASSEMBLYQUANTITY)

this one for the production date

=if(isnull(DATEPRODUCTIONFINISHED),PLANNEDPRODUCTIONENDDATE)

How do I avoid the double lines per  product?

Thankyou in advance for the help.

[Simon4]

to add:

When DATEPRODUCTIONFINISHED is not null, the production amount transfered to the stock because the product is finished, so it is no longer in production.