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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Total Issue?

Status
Not open for further replies.

Bennie47250

Programmer
Nov 8, 2001
515
US
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
 
See my response in the 'other topics' forum:
thread149-258747
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top