how to find % of each type of value in a field?
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.
FMP 9 A
mac os 10.5.8