2 Replies Latest reply on May 10, 2017 9:24 AM by Kunal Das

    need to use LOD may be - p

    Kunal Das

      i have following data in my table

       

       

       

       

      Order id || price

      null 10

      1 20

      2 30

      3 40

      4 50

       

       

      output should be

       

       

      order id || individual price || total_prirce  

      1 || 20 || 150 

      2 || 30 || 150

      3 || 40 || 150

      4|| 50 || 150

       

       

      The null value wont be displayed in output table - how to do it ?