Distinct Count Summary

[gkrenton]

Seems simple but keep getting stuck - 1 table report that sums up the total invoice value & all I want to show is the invoices greater than $100.00 AND also a distinct count of invoices that are greater than $100.00

I have grouped on a the 'sum' of invoices but if I do a count it includes all invoices in the detail vs just those meeting the criteria.

Did create a if statement
if Sum ({sales.sl_price}, {sales.sl_inv_num})>=100.00 then 1 else 0 but am unable to 'sum' this number when I put it in the group total. And not sure where to go from here.

Help?

Thanks

Gina

 

[MrBillSC]

Try grouping on invoice number.
In invoice number footer, insert a running total that is a distinct count. In the evaluate formula, select "use a formula" and click the X-2 button. In the formula enter

Sum ({sales.sl_price}, {sales.sl_inv_num})>=100.00

This may work or at least get you on the right track.

MrBill

 

[gkrenton]

Running total - ah so says the blind women. Yes that gets me on the correct track, actually looks like if I just do a 'distinct' count that changes on the record of inv it gives me the same result as if I do it on a formula.

Thanks

gina