Problems in script

[swarnendu]

Hello guys i have facing a problem in script level.

i want to pick value in row using condition. please see my attach file.

i have two filed which name one is opening quantity and one is closing quantity

i will create a calculated filed which name is  NewOpqty.

please see my image file and also see my script if you have any idea then please share with me.

i need this condition if(opening quantity<>0 ,opening quantity,peek(opening quantity)) and also need this condition 

if closing quantity<>0 then peek(closing quantity) or opening quantity.

But some how my condition will not working.

Thanks in advance

Swarnendu.

[Anil_Babu_Samineni]

To remove all zero rows you could use Len(Calculation)>0 as FieldName, ......

[swarnendu]

Hi Sunil,

I have two field 1 have only opening quantity but its have no date  thats why i already doing generate date till as on date.

i have also another field which name is closing quantity which have full transaction date i want to marge both field and create a another field which name is newopqty .

just i need like i have first opening quantity so its show me first date opening quantity then its check next row

if next is zero and closing <>0 then next row peek closing quantity otherwise its peek only opening quantity in next row