8 Replies Latest reply: Dec 5, 2013 3:31 AM by Kaushik Solanki Branched to a new discussion. RSS

    Generate new records from existing records

      I have a table like:

      ItemCompAmount
      1A11
      1B4

      Now I want one more record for all comp (A,B here) which is a calculated one (say Item ->Calc3) like

      Calc3 = Item->1*2

      So out put should be like:

      ItemCompAmount
      1A11
      Calc3A11*2=22
      1B4
      Calc3B4*2=8

       

      Note: In real scenario, there would be many more items and comps

       

      Please help.