12 Replies Latest reply on Sep 25, 2013 2:49 PM by Jonathan Drummey

    Table calculation

    parvinder.bindra.0

      Hi There,

       

      I am struggling with creating table calulation for the scenarion

       

      PN          Date                    Unit Price

      06351     April 02, 2013       240

      06351     May 05,2013        240.5

      06531     July 31,2013        240.6

      06533     April 10,2013        50.1

      06533     April 15,2013        50

      06533     Jun  10,2013        49.9

       

      I need to create table calculation where the unit price difference is computed from the record unit price at every PN

      2nd and 3rd record price should be compared with first and similarly 5th and 6th record is compared with 4th record price.

       

      How do i achieve this through table calculation, pls suggest

       

      Thanks,

      Parvinder