Bennie47250
Programmer
Crystal Version 7.0
I have two tables joined together, a sales table and a sales forecast table it is an = join on the sales region field. The sales forecast table is forecasted by month. I’m attempting to show total sales for the first 3 months of 2002 and the total forecast for the same time frame. When the two tables are just joined together, I receiving the correct sales numbers. When I attempt to also show the total forecast for the 3 months, the sales numbers increase by X 12 (if it was 100, after it is 1,200)
I’m attempting to show the forecast in a running total which is fairly straight forward. It is the sum of units, the evaluation is a formula of region and month <=3 and it never resets.
I quite certain the units are X 12 as the forecast table has 12 entries in it.
Any thoughts on how this can be done correctly will be greatly appreciated. I have tried every table link available in Crystal to no avail.
TIA
I have two tables joined together, a sales table and a sales forecast table it is an = join on the sales region field. The sales forecast table is forecasted by month. I’m attempting to show total sales for the first 3 months of 2002 and the total forecast for the same time frame. When the two tables are just joined together, I receiving the correct sales numbers. When I attempt to also show the total forecast for the 3 months, the sales numbers increase by X 12 (if it was 100, after it is 1,200)
I’m attempting to show the forecast in a running total which is fairly straight forward. It is the sum of units, the evaluation is a formula of region and month <=3 and it never resets.
I quite certain the units are X 12 as the forecast table has 12 entries in it.
Any thoughts on how this can be done correctly will be greatly appreciated. I have tried every table link available in Crystal to no avail.
TIA