9 Replies Latest reply on Oct 10, 2013 6:41 AM by try67

    PLEASE HELP: PDF Forms, creating average formula for text?

    misslcrumb

      Hello,

       

      I really hope somone can help. I cannot find any answers to my questions on the internet, google etc.

       

      First time using Acrobat. Im pretty quick learning on compters however the formulas my boss has asked me to do I have no idea if they are possible.

       

      We have a report form for exams and each section I need to calculate the average mark for that section.

       

      There are 3 questions for the first section. There are dropdowns for distinction, Merit, Pass and Below pass to select for each questions.

       

       

      Please see picture attached to show you what I mean.

       

      I want to be able to calculate the most selected/average dropdowns selected and not count the N/A's into award1 field?

       

      The fields must be text and cannot be numbers.

       

      so for example, track 1 got a distinction, track 2 got a Merit, Track 3 got a distiction. all other fields left n/a

      Screen Shot 2013-10-10 at 12.15.12.png

       

       

      is there anyway to do this also is there any way to exactly the same as above as check boxes? - please see picture attached

       

       

      Screen Shot 2013-10-10 at 12.17.59.png

      I appriciate any help. I am working on a mac

       

      Thanks

       

      Lauren