Hi!
I use CR 8.5 and SQL database. I have a running total that summarize a field. I need to evaluate it on a change of month (group #3) and reinitialize it on a change of year (group #2). I have another group (group #1 : currency) that I need to do another calculation. Let me explain. I have the month of january and february of 2003 and 2004 so 4 numbers that I need to count and it should go like this:
Group by month (group #2)
200301 : 1.2
200302 : 1.3
200401 : 1.6
200402 : 1.4
I need to sum 2003 : 2.5 and sum 2004 : 3.0. After that, I need to take the result of 2004 minus the result of 2003 : 3.0 - 2.5 = 0.5. This result needs to be in the group #1. I was thinking of a running total that evaluate on a change of group AND on a formula but that is not possible. Anybody have any suggestions?
Thanks in advance,
Bud
I use CR 8.5 and SQL database. I have a running total that summarize a field. I need to evaluate it on a change of month (group #3) and reinitialize it on a change of year (group #2). I have another group (group #1 : currency) that I need to do another calculation. Let me explain. I have the month of january and february of 2003 and 2004 so 4 numbers that I need to count and it should go like this:
Group by month (group #2)
200301 : 1.2
200302 : 1.3
200401 : 1.6
200402 : 1.4
I need to sum 2003 : 2.5 and sum 2004 : 3.0. After that, I need to take the result of 2004 minus the result of 2003 : 3.0 - 2.5 = 0.5. This result needs to be in the group #1. I was thinking of a running total that evaluate on a change of group AND on a formula but that is not possible. Anybody have any suggestions?
Thanks in advance,
Bud