Hi all . What mathematical formula to calculate the percentage of my form report chart.

  • Profile Image
    ElectroCity
    Asked on July 05, 2011 at 02:49 AM
  • Profile Image
    liyam
    Answered on July 05, 2011 at 03:48 AM

    Hello ElectroCity,

    Can you please provide us more details regarding your form or the details to be calculated?

    Thanks,

    Liyam

  • Profile Image
    ahmad_faisal
    Answered on July 05, 2011 at 04:04 AM
    Dear Liyam,



    Thanks you for getting back to me



    My form include as “rating services” in my store



    Excellent

    Good

    Weak



    I make my report as (chart report)



    I want to ask how I can calculate my results …for example



    19 customers rating services as (Excellent) = 86%

    8 customers rating services as (Good) =28%

    1 customer rating services as (Weak)=3%

    That’s calculated by MS Excel but I need the Percentage formula % of my form results



    Thanks again and I’m Sorry for all these questions



    Ahmad.F

  • Profile Image
    allanftd
    Answered on July 05, 2011 at 04:25 AM

    Hi Ahmad,

    To answer for Liyam, if you're interested in knowing just the formula to get the percentage, here it is:

    % who answered Excellent = (# of people who answered Excellent / total number of respondents) x 100

    % who answered Good = (# of people who answered Good / total number of respondents) x 100

    % who answered Weak = (# of people who answered Weak / total number of respondents) x 100 

    Hope the above info addresses your concerns. Please let us know if we can be of further assistance.

    Thank you for using JotForm!

    JOTFORM SUPPORT

  • Profile Image
    ahmad_faisal
    Answered on July 05, 2011 at 04:47 AM
    Yes, Yes, Yes, Yes,

    Thank you too much really for your help



    Thanks for all

    J



  • Profile Image
    allanftd
    Answered on July 05, 2011 at 05:11 AM

    Salam Ahmad, you're most welcome! Please let us know if we can be of further assistance.

    Thank you for using JotForm!

    JOTFORM SUPPORT