This content has been marked as final. Show 3 replies
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
Thanks in Advance.