Parameter that messes up calculation

[rhoneyfi]

Hello,
I am using CR 9.0 and have a parameter that is messing up a calculation because it seems that the suppressed records are still being calculated. Basically, here is what I have.
I have a report that shows the # of customers at each of out 50 stores. The report is grouped by Region (East, West, Europe) and then by the location of the store. I then inserted a summary that gives me the average # of customers for each region. I have inserted a paramter that more or less says "only show me the stores that have at least 25 customers". The problem is that the summary seems to be reflecting those locations that also have less than 25 customers. How do I fix the problem so that the average summary only reflect the average for stores that have 25 clients or more (basiucally ignores those that are suppressed)

 

[fredp1]

The suppresion logic, doesn't change the summary calculation because the records are not excluded, they are just not displayed on the report.
You'll need to create a formulae that uses the suppression logic to eliminate the value that you are trying to summarise.
e.g.
{@Customer Counter}
if {?your parameter} then 0 else 1;

then you can summarise the new variable.
(If your parameter is true(to suppress) then 0 else 1)
Add this to the detail section and you should be okay.

Fred

 

[lbass]

Try using the running total expert. Select {table.customerID}, count, evaluate based on a formula:

count({table.customerID},{table.store}) > 25

Reset on change of group (region).

-LB

 

[dgillz]

Alternatively, don't suppress these records, just exclude them from your report entirely by using the same logic you are currently using to suppress the records in a record selection formula.

Click on report, edit selection formula, record and enter your formula.

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