Trying to create a "ranking"

[Pablo Ramirez]

Hello,

I am trying to build a simple application that assigns points to people according to certain activities and at the end it adds the points for each one of them and ranks them from highest to lowest. So far I have not been to do that last part.

I have tried many things, playing with portals, scripts with no luck. The problem is in the Reports Layout, I deleted all my trials/tests, to have a cleaner view.

Any help would be very appreciated

Pablo

Points.zip

[Pablo Ramirez]

I think I am overthinking this!!!!!!

Pablo

[Pablo Ramirez]

How can you show the records in a portal without repeating them. If I assigned points to different persons every week, then how can I list them without repeating names?

[RalphL]

Sort on the Points field.

[Pablo Ramirez]

Thank you but perhaps I did not explain correctly. Please take a look at the attached file. the reports layout shows the sorted records with the total score for each person. But the names are repeated.

Could you please help me on this issue?

Thank you

Pablo

Points.zip

[-Queue-]

Put your sum calculation in your Officers file and then use a portal to display them, sorted by the sum.

See attached.

score.zip

[RalphL]

Lets say you have a file People with the fields ID (an autoentered serail number) First Name, Last name, etc. Then you have a field Scores with the fields ID from the people file, Date and Score. In People you can have a portal to Scores which will show the date & scores for the person of that record. You can calculate the total score for that person using Total = Sum(Scores::Score). You can sort the records in People by the Total. This may not be very fast since the calculation is unstored.

Display this in list view to see the people and their scores.

[Pablo Ramirez]

Thank you very much. Now it works excellent!!

Pablo

[Pablo Ramirez]

Hello,

I had to add an extra thing that pretty much "damaged" the portal for some reason. Basically I added a radio button that depending on the outcome (yes,no) will assign points to the person.

I don't know why the portal is not sorting the records in descending order. I compared everything with the file you previously sent me but still it does not work.

I truly appreciate your help

Cordially

Pablo

Points.zip

[-Queue-]

From a quick glance, it looks like you're using the wrong relationship for SumScore. It shouldn't be based on a constant. Use the FF relationship instead.

[Pablo Ramirez]

Hello,

Well, the FF relationship is the same I am using now but still it does not work.

Any other ideas would be greatly appreciated.

Thank you

Pablo

[-Queue-]

Did you change SumScore in the Officers file to be Sum(Evaluation of MeetingsFF::Sum Score)? This is what I was referring to. It calculates correctly when you use the correct relationship.

[Pablo Ramirez]

Wow, thanks a lot that does it

Pablo