AnsweredAssumed Answered

how to find % of each type of value in a field?

Question asked by slaglemark on Mar 10, 2010
Latest reply on Mar 10, 2010 by philmodjunk

Title

how to find % of each type of value in a field?

Post

hi, thanks for your time

 

my issue is this:

i have a field that has 3 possible values: +, o, -

i want a field that shows me the % of each of the values in that field.

so, for field1 i want to know that 32% are +, 44% are o and 24% are -.

right now im saying if field 1 = "1"; 1, 0

then doing a summary total of field, then yet another calc field

10 calculation/summary fields for each of the original +,o,- fields

of which there are 25.  not good, as you can see.

im looking for a better option.

any ideas?

thx!

 

FMP 9 A

mac os 10.5.8

 

-m









Outcomes