3 Replies Latest reply on Jun 6, 2012 8:23 AM by Tracy Rodgers

    Percent calculation from a group

    Allison Suarez

      I have divided some service data into "Other" and "Non-Other" by Employee Position using the following calculation:

      if [Problem Type] = 'Other' or [Problem Type] ='Other: Capture details in case notes' or ISNULL([Problem Type]) then 'Other'  else 'Non-Other' end


      The result is below.

      Agent 1         Other           6,341

                          Non-Other     32,014

      Specialist     Other            1,059

                          Non-Other     3,350


      What I can't figure out is how to now divide the "Other" value by the "Non-Other" value to get a percentage.  I know this should be terribly easy, but I can't seem to figure it out.

      Thanks for any help you can offer.