7 Replies Latest reply on Nov 8, 2018 7:58 AM by Paul Wachtler

    Calculation to count difference in 2 rows (kinda)

    Jean Picard

      I need to count the number of times dates are the same but product changed.

       

      sample.jpg

      Wish I could get this to work but  can't compare Sting and integer error:

      IF [Service Date]=[Date] AND LOOKUP(ATTR([Product]),-1) != ATTR([Product])

      THEN 1

      ELSE 0

      END

       

      Need to know if "Product" changed on "Service Date".