7 Replies Latest reply on Mar 1, 2017 6:04 AM by Sherzodbek Ibragimov

    IF Formals: Need to identify if 2 values are present at the same time, but when you run it, it calculates everything individually...

    athena.nader

      Dear All,

       

      I've been struggling with this calculation. I've tried it in several different ways but I can't manage to make it work. I need to know which customers are buying 2 products a week.

       

      Essentially the formal would be:

      IF Shoes>0 AND Shirts>0 THEN "A" Else "B" END

       

      But when you run it, It first calculates 1 and then the other so its never "B".

       

      Ultimately I want to show just customers that are buying 2 products a week. and ideally the volume in each.