So I've been building a bunch of different reports and I was thinking it would be super cool if we could use Count/Sum IF in the summarized reports.

As an example, we have a new process bringing in submissions that may or may not involve credit card charges.

These submissions include 1 or more attachements, which can individually be accepted or rejected.

If we had a Count/Sum IF option, for the reports, and I could add the same variable multiple times, I could create some really useful reports like:

• Total Submissions (Count instances)
• Total w/Charges (Count IF charges > 0)
• Accepted Documents (Count documents IF status = Accepted)
• Rejected Documents (Count documents IF status = Rejected)

I have a workaround where I populate a form variable with a 1 or 0 for the fields I want to track in my reports, but I just thought something like this could really kick reporting up a notch