jw970170
Programmer
- Aug 8, 2005
- 38
Hello,
I am very new to crystal reports. I'm trying to make a formula that sums by month. This is what I have
sum({table.Value},{table.TimeStamp}, "monthly")
The problem is that it is not summing correctly. Here is the data I am using
5/15/2004 4:30:00 AM 44190
6/20/2004 4:30:00 AM 40100
5/15/2004 4:31:00 AM 50000
7/15/2004 4:31:00 AM 75000
The report is grouped by month. On the May page, it sums both may and june to give 188380
On the june month it gives 80200 (which doesn't even make sense...it seems to somehow be grabbing data from another table)
I should probably mention that I've tried to include two tables in my report but not have them linked. It gave me some warning when doing this but let me continue
I am very new to crystal reports. I'm trying to make a formula that sums by month. This is what I have
sum({table.Value},{table.TimeStamp}, "monthly")
The problem is that it is not summing correctly. Here is the data I am using
5/15/2004 4:30:00 AM 44190
6/20/2004 4:30:00 AM 40100
5/15/2004 4:31:00 AM 50000
7/15/2004 4:31:00 AM 75000
The report is grouped by month. On the May page, it sums both may and june to give 188380
On the june month it gives 80200 (which doesn't even make sense...it seems to somehow be grabbing data from another table)
I should probably mention that I've tried to include two tables in my report but not have them linked. It gave me some warning when doing this but let me continue