I have a requirement like this
Code: Select all
Col1 Col2 Col3
A - X
A -1 X
A -3 X
A 2
A 5 X
A 0 X
So while checking this, how to skip the first values of Col2 (because no values will be there), from second values I have check whether negative or positive. If negative or equal to zero, the Col3="X" and also the above record Col3 values should be "X"
Any suggestions please
Appreciate your help in advance
Thanks a lot