Need to find a way for Data to populate data down a column based on previous lines and
reset on multiple parameters
The issue I have is that value in column 'RunT' is correct when there is a value in 'RunLastR' other than 0.
If 'RunLastR' is = 0 then I need the value that was last reported where 'RunLastR' <>0 from the Value in 'RunT', and
copied down the 'RunT' column until the next Non 0 value in the 'RunLastR'
if the next row shows a non 0 in RunLastR that becomes the record that repeats down the column for 'RunT'
The Data needs to reset Based on StockCode, AllInvWhse...
If we need to add few columns to get this to work I am ok with that
Sounds confusing as hell but it is the best I can do