Running Total using Evaluation Formula

[jbhsuman]

I am trying to use a running total to count the number of invoices. The Invoice number can duplicated depending on the number of line items created for the invoice

example:

Inv Item Description
1 1 xyz
1 2 abc
1 3 def
2 1 ghi
2 2 mno
3 1 ghi

I need to evaluate the count once the invoice number changes. the forumla I used is

({DATA12.INVOICE} <> Next ({DATA12.INVOICE})and Month ({DATA12.DATE})= 12)

.

The formula works fine until I reach the last record. At the last record, the formula does not count the last record. I’ve tried the following variations with no success.

 ({DATA12.INVOICE} <> Next ({DATA12.INVOICE}) or NextIsNull ({DATA12.INVOICE}) and Month ({DATA12.DATE})= 12)

({DATA12.INVOICE} <> Previous ({DATA12.INVOICE})or NextIsNull ({DATA12.INVOICE})and Month ({DATA12.DATE})= 12)

Any suggestions?

 

[jbhsuman]

BTW, I am using CR 9 and advantage DBF

 

[Madawc]

In Crystal 8.5, the best way would be a running total with DistinctCount

Madawc Williams
East Anglia, Great Britain

 

[jbhsuman]

TY Madawc. I didn't even think of that. Sometimes I think I try to make things more difficult than they need to be.

Thanks.