Percentage of various results

[mrkstpls@gmail.com]

I have a record with a field which can have only one of nine possible results - 1,2,3,4,5,6,7,8,or 9

Over a given set of records I want to be able to summary what percentage of the records had a 1, had a 2, etc.

The solution I've got is pretty kludge. I created 9 calculation fields, TheNumberOneField= "if(field=1,1)" ; TheNumberTwoField= "if(field=2,1)"; and so on.

The I create 9 summary fields, etc etc.

 

There are many other fields like this in my database, but creating the summary mechanism above is too time consuming. Is there a more elegant (and time saving) way to do this?

Many thanks

[Steve Martino]

If this is what you are looking for, you definitely over complicated it.

Percentage.zip

[mrkstpls@gmail.com]

This is perfect.

Very grateful for your time and effort.