6 Replies Latest reply: May 18, 2018 12:41 PM by Salvatore Strazzullo RSS

    New table with less rows

    Salvatore Strazzullo

      Hi,

       

      I have a table Table1 with 3 rows (A,B,Costs):

       

        

      Table1
      Settore PL
      A 30
      B 20
      Costs (10)

       

      I have to produce a new table Table2 like this:

        

      Table2
      Settore PL
      A 22
      B 18

       

      where

      Table2.A = Table1.A + 80% Table1.Costs

      Table2.B = Table1B + 20% Table1.Costs

       

      How can I create the new Table2?

       

      Thanks!

       

      Savio