4 Replies Latest reply on Dec 6, 2017 10:08 PM by Michelle Barrineau

    If Statement with two Dimensions?

    Michelle Barrineau

      Hi,

      First off, thank you for reading this.  I'm awed and grateful that this forum exists and that so many people are willing to help.

       

      So I am trying look at total sales for products coming from different countries.  The problem I have is that while the product may physically come from a specific country, sometimes they are being used in a domestic brand, and should be classified as domestic instead of imported. 

       

      I have no doubt this is very simple to do, I just have no clue how to do it.  I tried doing an IF THEN statement, but I don't know what syntax to use or if I can mix two different Dimensions in the same statement.

      IF [BRAND ORIGIN]= DOMESTIC THEN [COUNTRY]=UNITED STATES

      END

       

      Thanks again for your help.

      Michelle B.