"The Summary/Running total Field coulf not be calculated." Error 1

[debrichards]

I am trying to summarize a Total per Month column for cases sold. The report gave me eaches sold first, which I converted into cases using the formula below. Now when I try to total the cases by month I get the following error message: "The Summary/Running total Field could not be calculated."

The report is derived from a Access 2000 database.

I may be going about this all wrong. I am a new user learning by trial and error. Any suggestions would be much appreciated.

The formula that generated the error message on was "Sum ({Case Calculations})" (no quotes on formula).

I am using the formula below to convert eaches to cases for products. {@Case Calulations}:

if{Q-MainTableWithStates.SKU}="68967" then Sum ({Q-MainTableWithStates.QTY_Each}, {Q-MainTableWithStates.SKU})/8 else
if{Q-MainTableWithStates.SKU}="69101" then Sum ({Q-MainTableWithStates.QTY_Each}, {Q-MainTableWithStates.SKU})/300 else
if{Q-MainTableWithStates.SKU}="23008"or {Q-MainTableWithStates.SKU}="68963" or {Q-MainTableWithStates.SKU}="40510" then Sum ({Q-MainTableWithStates.QTY_Each}, {Q-MainTableWithStates.SKU})/15 else
if{Q-MainTableWithStates.SKU}="68967" then Sum ({Q-MainTableWithStates.QTY_Each}, {Q-MainTableWithStates.SKU})/ 8 else
if{Q-MainTableWithStates.SKU}="23032" then Sum ({Q-MainTableWithStates.QTY_Each}, {Q-MainTableWithStates.SKU})/9 else
if{Q-MainTableWithStates.SKU}="23128"or {Q-MainTableWithStates.SKU}="68978" then Sum ({Q-MainTableWithStates.QTY_Each}, {Q-MainTableWithStates.SKU})/4 else
if{Q-MainTableWithStates.SKU}="49200"or {Q-MainTableWithStates.SKU}="49100" or {Q-MainTableWithStates.SKU}= "49100CA" or {Q-MainTableWithStates.SKU}="69260" or {Q-MainTableWithStates.SKU}= "40513" then Sum ({Q-MainTableWithStates.QTY_Each}, {Q-MainTableWithStates.SKU})/12 else
if{Q-MainTableWithStates.SKU}="SK008"or {Q-MainTableWithStates.SKU}="SK960" or {Q-MainTableWithStates.SKU}="68832" or {Q-MainTableWithStates.SKU}="68970" or {Q-MainTableWithStates.SKU}="68973" then Sum ({Q-MainTableWithStates.QTY_Each}, {Q-MainTableWithStates.SKU})/6

 

[synapsevampire]

The database should have this case intelligence built in to a reference/look up table (parboil the architect immediately), but I think that what your formula is missing is a final:

else
0

Since that will assure all rows return a value.

-k

 

[dgillz]

You cannot summarize a formula that uses the next(0 or previous() function, a formula that is evaluated WhilePrintingRecords, or formula that is itself a summary.

Since {@CaseCalculations} is itself a summary field, that is your problem. You need to create a running total field, or use variables, to summarize this.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[synapsevampire]

Ahhh, right, good point, dgillz.

Create a similar formula and eliminate the ,{group} from the sum.

-k