4 Replies Latest reply: Apr 14, 2014 5:12 AM by Toni Kautto RSS

    fields comparison

    Mambi Badi

      Hi everyone,

      from the exemple below i want to know if the product price had changed over years and display the result ( changed or unchanged ) in the COMP column

      the number of years is more important so i don't want to use many nested if

       

      Pord

      YEAR 1

      YEAR 2

      YEAR 3

      YEAR 4

      COMP

      A

      12

      13

      14

      15

       

      B

      12

      12

      12

      12

       

      C

      14

      14

      14

      15

       

       

      any idea ?