4 Replies Latest reply: Oct 9, 2016 10:45 AM by john cena RSS

    total in staright table

    john cena

      Hi i have the below data

       

      id        identiy     date                 time                  

      1.         1          Jan 1, 2016      0.02201673        

      2.         3         Jan 1, 2016       0.01105705        

      3.         27       Jan 1, 2016      0.02656042          

      4.         1         Jan 1, 2016      0.26666667        

      5.       175       Jan 1, 2016      0.51282051         

      6.       144       Jan 1, 2016      10                       

       

       

      and my output should be like this

       

      datenew_column
      Jan 1, 2016459.234

       

       

      the new_column formula is   for every row it should calculate  (identiy * time* 0.3 )

      and sum up every row  to get the  new_column  output

       

       

      Regards