Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Basic Question

Status
Not open for further replies.

ptrifile

Technical User
Aug 10, 2004
457
0
0
US
I am struggling with what has to be a very simple basic thing. I have a very simple report that is pulling 2 different "skillsets" calls offered(sum) from a table and i am grouping by "timestamp" by week. When i run the report i am getting the following result:

12/30/2012 84.00
1/6/2013 113.00
1/13/2013 37.00
12/30/2012 5128.00
1/6/2013 5746.00
1/13/2013 2329.00

I was under the assumption that by grouping by "timestamp" the data would be all inclusive for both "skillsets" not for each one. I would have been expecting the following result:

12/30/2012 5212.00
1/6/2013 5859.00
1/13/2013 2366.00

maybe i have been looking at this report too long but i cant figure it out and it just seems so basic.

thanks for any help!

Paul

 
hi ptrifile

why disregard? what did you discover that helped you resolve this?

I'm a relatively new CR developer and come here sometimes just to browse and see other posts to learn about problems and how they were resolved, so am curious as to what you found to give you the report as expected. did it have to do with the time stamp include the time, not just the date?

thx
kim
 
It looks like there might have been a suppressed inner group, but kim is right--you should explain the resolution in order to make the post useful to others.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top