6 Replies Latest reply: Oct 13, 2017 4:52 AM by Bruno Paulo RSS

    Subtraction of 2 rows depending a 3rd row (Script)

    Bruno Paulo

      Hi community,

       

      I have something like this. 

       

      Product   TypeProd   A      B

       

      1               7145     1000   0
      2               7289     0          2000
      3               4888     2500    0
      4               7265     3200    0
      5               1477     0          500
      6               3655     1000    0
      7               1788     1500    0

       

      So, i want sum(A) - Sum(B) but only when TypeProd start with 71 or 72 and i want to do this in script. Any ideas?


      Thanks in advance

      Best Regards

       

      Bruno Paulo