count not working in crystal

[ncchish]

I’m having trouble getting a count. I’m using crystal 11. I have totals in the group footer and the detail line has the breakdown of what is in my footer. What is in the detail section adds up to what is in the GF. The problem is I need to get a count of the producers in the detail section who have amounts > 1 to show on the GF row. So, for the example below I would have a count of 2 since 2 producers in the detail section have amounts > 1. My formula is not working and I'm not sure if I have it set up correctly. Any help would be appreciated. Thank you.

Formula:
//count
If (sum({TABLE_A.PROD_AMT},{TABLE_A.RPT_NBR})) > 1.00 then DistinctCount ({TABLE_A.RPT_NBR}, {TABLE_B.AGCY_NBR})


GF: Agency total: $25,000 2 producers
Det: John Smith $0
John Doe $24,000
J. Cash $1,000
b.White $0

 

[briangriffin]

You should consider using the running total expert, but usually I just create a formula in the details section and suppress it:

if {TABLE_A.PROD_AMT} > 0 then 1 else 0

Then you can create a sum in both the group footer and report footer.