25 Replies Latest reply on Feb 12, 2013 8:48 AM by stcdesigns

    Dividing fields

    stcdesigns

      Is there a way to create a a field where I can total sum of divided by the total number of questions answered. For example, I have a client who wants his employees to answer at least 10 of the 12 questions (2 may not apply to all). Some may answer all 12 but others may answer only 10. Answers are a rating scale of 1-10. To be fair he doesnt want an average because it would skewed if some only answered 10 as oppose to those who answered all 12.

       

      He wants the formula for adding the sum of all questions answered and dividing it by the total number of questions answered? Sorry this hard to write!!!