SUPPRESSING DUPLICATE VALUES AND THEN GETTING A SUMMARY

[netrusher]

I have one grouping in my file (SOE Events). I have used the following under Insert, Section, Details, Suppress (No Drill-Down formula.

{4-5TSOEEVENTTIMES.EVENT_NUMB}=NEXT({4-5TSOEEVENTTIMES.EVENT_NUMB})

This works and suppresses the duplicate Event Numbers. I then try and do a Summary of the Event Time Field by Group and it gives me a summary time of all the records including the ones I suppressed. How can I get A Summary of only the records left on the screen and not all records combined (both Suppressed and Viewable)?

 

[MisterMo]

try and use a running total and on the evaluate section choose on change field and add your field there

{4-5TSOEEVENTTIMES.EVENT_NUMB}


-Mo