Skip to Content
0
Former Member
Oct 27, 2011 at 04:37 PM

Crystal Reports - need formula to count member if member amount >0

854 Views

I'm using Crystal Reports 9.2.2.634. I need a formula that would count the number of members whose payment total is greater that zero. In this sample data set I want it to return a count total of 3 and an amount total of $1,500.00

Date ID Name Item Amount

3/1/11 1234 Smith Annual Fee $500.00

5/1/11 6489 Jones Annual Fee $500.00

1/1/11 7846 Brown Annual Fee Installment 1 of 5 $100.00

2/1/11 7846 Brown Annual Fee Installment 2 of 5 $100.00

3/1/11 7846 Brown Annual Fee Installment 3 of 5 $100.00

4/1/11 7846 Brown Annual Fee Installment 4 of 5 $100.00

5/1/11 7846 Brown Annual Fee Installment 5 of 5 $100.00

6/1/11 5847 White Annual Fee $500.00

6/3/11 5847 White Returned Check $(500.00)

Total Count 3 Total Amount $1,500.00

Thank you