history data to be included into current data

[#1]

history data to be included into current data when the current data is null like

     If my quantity is Null then it should get to the immediate historical data and it should be included into the current data

QTY          YEARMONTH

1025          MAR-2014

564            MAR-2014

000            APR-2014

565            MAY-2014

Here my month april doesnt have Quantity it is null then it should goto the immediate previous month March and it should display as 564 not 1025

[rohit214]

hi,

PFA

Thanks

Rohit

[#3]

Hi ,

Thanks for the  reply those application is helpful but its not full filing my condition

Its taking a value if have two or three filters and looking out the resullt its displaying a different output

and other thing is that the script you have written show the previous itself right or it goes on in a loop until it gets a value