2 Replies Latest reply on Sep 8, 2016 8:43 AM by Joe Oppelt

    IF OR THEN Statement Valid, but not Giving Results

    Alyssa Franklin

      I have written the below calculation. There is no error coming up in the calculation and the formula works for the [Band] and [Auth HC SLT] fields. The other fields are being assigned "No" for some reason. All fields are Strings and are coming from the same Data Source and Sheet. Any idea of why some of the fields are not being given the value of "No?"

       

      I can't attach the full workbook because of the data being private, so I hope this is enough information. Thank you!

       

      //code specifies who is excluded from Certification Counts by Highest Rule available

      //Band exclusions of H6-H8

      IF (ATTR([Employees (Tableau Staffing Snapshot)].[Band])="H6"

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Band])="H7"

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Band])="H8"

      //Job Title exclusions of Business Analyst and Business Support Lead III

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Job Title])="Business Analyst"

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Job Title])="Business Support Lead III"

      //Director exclusion of Richard A. Martinez

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Director])="Martinez, Richard A." 

      //Auth HC SLT exclusions of Ray eIMS, Murray MMR, and Stamatelatos

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Auth HC SLT])="Ray eIMS"

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Auth HC SLT])="Murray MMR"

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Auth HC SLT])="Stamatelatos"

      //Full Name exclusions for those who don't fit in specific rule

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Full Name])="Alejandro, Janice"

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Full Name])="Bergeron, Erin H."

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Full Name])="Franklin, Alyssa E."

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Full Name])="Martinez, Richard A."

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Full Name])="Miller, Meredith"

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Full Name])="Rodriguez-Santos, Virmarie"

      OR ATTR([Employees (Tableau Staffing Snapshot)].[Full Name])="Zuerner, Chris")

      THEN "Yes"

      ELSE "No"

      END