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

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.

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

See attached for example of implemented method.

correctsum.zip

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