Don't want to Sum Suppressed values 1

[mulema]

Hi,
I am using Crystal 8.5 on Oracle 8i.
I am summing up my Totals Sales Amount on GF1. My detail line has a Format Section formula, where I am suppressing duplicate lines.
The problem I am facing is that my Summed Up Totals on GF1, is adding up these suppressed values as well. I need help on how to fix this.
( I have not been able to do a search on this site since the Search feature is still under construction. )

Thanks for your help.
Mulema.

 

[glalsop]

You could use the 3-formula method to manually sum your field. In the evaluation formula, use the same logic that you have applied to your suppression formula to determine whether to add to the sum or not.

Formula in GH:

whileprintingrecords;

numbervar mysum := 0;


Formula in detail section:

whileprintingrecords;

numbervar mysum;

if not(YourSuppressionLogic) then mysum := mysum + {table.field};

Formula in group footer:

]whileprintingrecords;

numbervar mysum;

mysum;

-Gary

 

[mulema]

Worked perfectly.

The NOT(SuppressionLogic) was my culprit. I added the NOT and was good.

Thanks.