5 Replies Latest reply on Mar 10, 2010 10:21 AM by philmodjunk

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

    slaglemark

      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