I have TimeTracker project where Members will record Daily Timesheet for each project. I'm trying to build Member Dashboard where I want to display his Total Hours spent for the current month.
Before you spend much more time on this, you might want to watch the NEW video for the improvements coming in version nine.
Might be easier for you.
And in those videos also you can see the statements he uses to get the counts.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Thank you Jaymer, I got the solution around this to display the counts, I'm missing to add "(" around where clause. After adding like below WHERE (Task.ps_AssignTo=LoggedInSystemUser) it worked for me.