Hey all,
I have a report with a formula field called ({Made it}) and I am having difficult time summing only the visible records of that field.

The report is setup to show only distinct records by using {table.record_ID <> previous({table.record_ID}) to suppress the duplicates. The report is grouped by state.

The formula field ({Made it}) looks like:

If {table.SLA} > 2880 then '1' else '0'

My hope is that I can get the average of how many are > than 2880 for each group. Everything seems to work okay math wise but when I double check the results it appears the field ({Made it}) is summing all records not just the unsuppressed records. How can I make a field that sums only the visible records and ignore the suppressed?

Is there something similar to this available?
DistinctSum({Made it},{@assigned_state})

Please forgive me if this sounds convoluted but it's only my second time posting.

Thanks

Edited by ravenous - 23 Feb 2015 at 3:50am

Hey, that worked great. Thanks. Now I gotta figure out how to get the running total into a bar graph!

Forgive me for resurrecting an old thread. I'm having a very similar issue. My results are filtered through variables set by a front-end app, though. I can't get my totals to reflect only the printed records. the running total field appears to be summing every record that passes through the record selection formula, but it's not affected by the front-end application filters, it seems. Where do I look first to narrow this down?