Jump to content

field count


This topic is 7563 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7563 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.