field count

[transit]

I am not shaw if I am posting in the correct forum, so if not please redirect me.

I have a field which is a calculation returning either 'correct' or 'incorrect' based on answers people give in other fields. What I would like is display on each record how many records are correct out of the total number of records.

any help much appreciated

[-Queue-]

Total number of records in the file or total number of current records found?

Create a calculated number field equal to 1. Then create a self-relationship (this file to itself) with the calculated field as both the left- and right-hand keys. Create another calculated field based on correct/incorrect, call it ci, with value field = "correct", substituting field with your correct/incorrect fieldname. Now create a third calculation field with value, Sum( selfrel::ci )/Status(CurrentRecordCount), if you're dealing with all records in the file, or Sum( selfrel::ci )/Status(CurrentFoundCount), if only currently found records.

[transit]

Thanks queue

I have created all that you have stated above but the fields constantly show the same results wheather correct or incorrect and however many records I do

eg

number field 1

ci 0

sum of 0

any suggestions

[-Queue-]

See attached for example of implemented method.

correctsum.zip

[transit]

Thanks Queue

What I missed from your calculation

Sum( selfrel::ci )/Status(CurrentRecordCount)

was that it was formated as a percentage, now that I have done that on mine it works.

It wasnt what I had asked for originally but that was probably me not explaning myself properly .

I like it, many thanks