7 Replies Latest reply on Sep 20, 2019 7:23 AM by Jim Dehner

    If 2 statements are true

    Victor Namnum

      I'm using Tableau 2019.1.3

       

      I'm trying to create a calculation that informs if a product is losing business in the south. Because the product is losing money in the 'South' I want it to populate '1' for the 'Calculation' formula.

       

      Here's my formula:

       

      Calculation

       

      IF [Region] = "South" AND [Profit]<0 THEN 1 END

      Tableau - Calculation.jpg

       

      Suggestions on how to fix my formula?