Running total issue

[Luvsql]

I have 3 groups. In GH3, I have a percentage calcuation based on the 2 summary fields in GH3. I have tried to restrict the report to only include {Percentage}>75, but it is not listed to restrict on.

I then suppressed GH3 for {Percentage}<=75, which works fine, but now I need to subtotal those amounts for GH1.

I created a running total field and of course, the {Percentage} field isn't available, so I used the exact formuala from the {Percentage} formual, which is based on restriction formula sum(x)/(sum(x)+sum)*100>=75 (for GH3). This does calculate the correct amounts for some customers, but some are completely wrong. If I show all deatils, those totals don't match anything.

Is there no way to restrict a report that has formulas based on summary amounts? I don't want to have to create a stored procedure to make this a very simple report, just to get a Top N Customer report.

 

[Bennie47250]

Your issue seems similar to an issue I just had. Refer to thread 767-955009 for the solution I used

 

[Bennie47250]

Sorry but the link did not work, Try searching for "need top n help" in the subject line in this forum and that should take you to it.

 

[Madawc]

Bennie47250, you need to post the link as thread767-955009, no space. What I normally do it cut-and-paste which works fine.

Madawc Williams (East Anglia, UK)

 

[lbass]

Running totals for a group will only be accurate when placed in the group footer. Also, since you are using suppression, you need to build in the reverse of your suppression criteria into the evaluation section (use a formula) of the running total.

You could have used group selection to limit the report to only those records that meet your criterion. You might need to use the formula contents in the group selection formula area, instead of the formula itself. The advantage of this method is that when you do the running totals, you would then no longer need to add the reverse of the suppression criteria into the running total.

-LB