About Ankit_Negi

Hi,   Please see the updated scenario below.   There is dev model and prod model(deployed mode). Originally there is numbered list marked as production list . But now there is new requirement to mark this numbered list as structural list. But if I will mark it as structural list in dev model and sync. with prod model(ALM); the data associated with the list(module data and list data will be lost in PROD model. I don't want to loose data. Can someone suggest workaround for this as i want to mark this list as structural list without loss of data.   Thanks ... View more

I am trying to figure out the difference between LEAD and LAG function; as we can get same value from future and past period by using both function.    for Ex: LEAD(x,-2,1000,STRICT) and LAG(x,2,1000,STRICT) will get the result from 2 period before the current cell. Can someone help me where we should use LEAD function .and not LAG function and vice versa   Thanks, Ankit ... View more