5 Replies Latest reply: Aug 26, 2013 10:34 AM by Alec Harf RSS

    Issue with Where in the script

    Alec Harf

      Hi Guys,

       

      I am having issue with using where in the script. If I comment the Where statement I get data and if I add it no data will show on the table.

       

      I noticed that the issue is in the and in the where statement..but not sure how to fix

       

      ActualYTDBalance:

      Load

      Year,

      Period,

      Name,

      Sum(AmountYTD) as  Amount

      Resident AA2

      where Name='1100' and Name='1105'

      Group by Year,Period,Name;

       

      Let me know if you can help!

       

      Best,

      Badr