Formula fields not available for Summary function

[kmarino]

I have 8 formula fields defined. Only 4 of them are available when I select the Insert Summary function on the Toolbar.

What would cause formula fields to not be available?

The following is the formula for the 4 fields that do appear:
If {V_CHK_VW_EARNINGS.CHECKVIEWEARNSCD} = {?Earning 1 Desired} then
{V_CHK_VW_EARNINGS.CHECKVIEWEARNSAMT}
else
0

The following is the formula for the 4 fields that do NOT appear:
If (Previous({V_CHK_VW_EARNINGS.COMPANYCODE}) = {V_CHK_VW_EARNINGS.COMPANYCODE}) and
(Previous({V_CHK_VW_EARNINGS.NAME}) = {V_CHK_VW_EARNINGS.NAME}) and
(Previous({V_CHK_VW_EARNINGS.FILE#}) = {V_CHK_VW_EARNINGS.FILE#}) and
(Previous({V_CHK_VW_EARNINGS.CHECKVIEWCHK#}) = {V_CHK_VW_EARNINGS.CHECKVIEWCHK#}) and
(Previous({V_CHK_VW_EARNINGS.CHECKVIEWCHKSEQ#}) = {V_CHK_VW_EARNINGS.CHECKVIEWCHKSEQ#})
Then 0
Else
{V_CHK_VW_EARNINGS.CHECKVIEWGROSSPAYA}

Does anyone have any ideas?

 

[dgillz]

In your case, the previous() function is causing the field to be unavailable to be summarized.

In general any field that is evaluated WhilePrintingRecords; uses the previous() or next()functions, is a summary itself, or refers to a formula that fits one of the above categories, cannot be summarized.

Take a look at using variables and the 3 formula approach as your solution. There is a good FAQ on this in the FAQ section. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, Crystal Reports and Goldmine

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[kmarino]

Thankyou. I guess it's back to Running Totals for me. I was trying to find a way to use the Summary function instead of the Running Totals.

Kathleen