2 Replies Latest reply: Feb 4, 2013 11:45 AM by Diego Monge Porras RSS

    Where clause not working (Resident Load)

      Hello,

       

      I have the below script;

       

      QUALIFY *;

      Chart3:

      LOAD

      AuditPhase,

      AuditPhaseID,

      [Region Only],

      NumYearMonth,

      [DDQ Submit]

      Resident TABLE1

      Where NumYearMonth = 27 and

      [AuditPhase]='DDQ' or [AuditPhase]='OSI' or [AuditPhase]='EDD';

       

      The NumYearMonth = 27 filter is not working, and after I run the script I still have all values in the new Chart3 table.

       

      NumYearMonth is a created field using the autonumber() function.