Excluding Suppressed fields from Sum

[maas]

Hello,

I need your help in excluding the suppressed amounts from the SUM in the group footer. In the details section, I am having duplicate deal no and amounts.So, in the Section Expert for the details sections, I performed a condition on the formula "Suppress" to suppress the duplicated fields which is:

{deal_no} = (next{deal_no})

The above condition is applied in the report and I was able to suppress the duplicates. Now in the group footer, I am performing a running total using the formulas to calculate the SUM for the amounts. However, this SUM is calculating the suppressed amounts and it is giving the results. So how to remove them from the calculation.

Thanks

 

[kenhamady]

Instead of suppressing, I would group by Deal and put all your display fields in the group footer. Then hide the details and the Group Header for DEAL. Once you have done that you can total the value by using a running total field (under parameters in the field explorer). Set the 'evaluate' setting in the middle of the running total window to be 'on change of group' and specify the 'deal' group. Leave the reset to never if this is a grand total, or if it is a group total you can set the reset to be on change of that group.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/