3 Replies Latest reply: Aug 22, 2014 2:46 AM by Pratik Chirmule RSS

    Garbage After Expression.

    Pratik Chirmule

      Hi All,

      Ive used the below script to give condition in script..


      Load count(distinct ID & Dept) as Count_IDDept Resident xyz where Dept = 'Fianance'; It gives the Proper count of Count_IDDept as a static number.

      But when i add other condition as,

      Load count(distinct ID & Dept & [Joining Date]) as Count_IDDept Resident xyz where [Joining Date]>=weekstart(date(now()),-1) & Dept = 'Fianance';

      It gives Error:

      It says "Garbage after  Statement



      Any suggestions?

      Thanks in Advance.