5 Replies Latest reply: Apr 10, 2014 8:22 AM by Sampath Kumar RSS

    Expression to Fill missing Values

    Ankit Gupta

      HI Guys..Gud Morning..

                                         i have one case, in that i have to fill missing values by previous available values, as -

      InvoiceLine ItemSales_Person_No.Sales_Person_Name
      50014958104570Sushaiv Sharad Wadekar
      5001495820
      50014958303983Sujit S Dixit
      5001495840
      5001495850
      500149586013131Prashant Kumar
      5001495870
      5001495880
      500149589031313Ashish Goel
      50014958100
      50014958110
      50014958111
      50014958112

       

       

      Sales Person for line item 20 is missing...than  it should be fill by previous line item 10, Similarly.. 40 and 50 should be fill by line item 30 Sales Person, 70 and 80 by 60 and 100,110,111,112 by 90....can anyone suggest code to fill missing value?

      please check test attachment...

      thanks in advance..

      Ankit