Form Calculations: How to get a highest value from multiple values?

  • Profile Image
    jannyfer.chua
    Asked on August 05, 2016 at 07:41 PM
    Hi,
    Thank you for your prompt response.
    How do I set a formula to calculate the highest total of the 4 totals and then for it to show related information to that total on the next page?
    e.g.
    Q1= 35
    Q2 = 30
    Q3= 22
    Q4= 18
    So the highest total is Q1 but instead of showing the actual formula to the user,
    [cid:image001.png@01D1EFB4.83DD5F90]
    It shows information related to that result on the Next Page:
    [Image result for prioritiser]
    You are a Prioritiser!
    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
    ...
  • Profile Image
    Mike
    Answered on August 05, 2016 at 07:45 PM

    This is possible to use a max function to get the highest value.

    Form Calculation - Math Function Reference

    Could you please explain the part about related results on the next page? Please note that we cannot receive image attachments by email. If you would like to share a screenshot, please see the next guide.

    How to include screenshot image in the support forum

    Thank you.

  • Profile Image
    jannyfer.chua
    Answered on August 05, 2016 at 09:45 PM
    Hi,
    What I am trying to do is create a quiz of 28 questions, of which every 7 questions targets 1 of the 4 elements.
    Based on the user’s answer, there will only be 1 element with the highest score.
    When that element is determined, they get their results (image & a description about their results) on the next page.
    So the user will only see the 28 questions and the image & result description.
    For example:
    Element Score
    1 (q1-7) 35
    2 (q8-14) 30
    3 (q15-21) 22
    4 (q21-28) 18
    1. A formula calculates the highest score total – element 1 (do I have to create a 5th Form calculation widget for this?)
    2. Displays only the image and textbody linked to element 1 on the second page
    ...
  • Profile Image
    liyam
    Answered on August 06, 2016 at 02:39 AM

    Hello,

    Unfortunately your screenshot did not appear. Please visit this link and post your image here instead: https://www.jotform.com/answers/899851

    If you need to have to find the highest score selected, and its value is not related or dependent to the value of those that are added, you will need to have a separate calculation field for it.

    We'll look forward to your update on this matter.

    Thanks.

  • Profile Image
    grade4pagasa
    Answered on August 06, 2016 at 04:01 AM

    Hi jannyfer

    This thread might be of help to you. The solution I shared with the Original Poster is dated Feb. 22 @ 6:00 pm. Below's the screenshot of the desired end-result.

    - Randy, fellow JotForm user 

     

  • Profile Image
    Nik_C
    Answered on August 06, 2016 at 04:14 AM

    Randy, thank you again for your contribution and workaround for this problem, we appreciate it as always!

    @jannyfer

    Please let us know how this works for you and if you have any further questions.

    Thank you!

  • Profile Image
    jannyfer.chua
    Answered on January 17, 2017 at 06:48 PM

    Sorry for the LATE response. I wasn't able to work out how to show the result with the highest score.

     

    For example:

    Score
    Quadrant 1: (q1-7) 35
    Quadrant 2: (q8-14) 30
    Quadrant 3: (q15-21) 22
    Quadrant 4: (q21-28) 18

    Quadrant 1 has the highest score, I want it to be the only result showing.

    But instead of showing:

    "Result: Quadrant  1"

    I want the result to show on the next page as:

     

    [Image result for prioritiser]

    You are a Prioritiser!
    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

     

     

    So I need assistance to:

    1) calculate to show only the Quadrant with the top score

    2) display the image & text associated with that Quadrant

     

    Thanks!

  • Profile Image
    Kevin_G
    Answered on January 17, 2017 at 11:01 PM

    @jannyfer.chua, 

    I have checked this form on your account http://www.jotform.co/form/70166925523861 and found that you have already added the 5th calculation widget and you are getting the highest value already: 

    I can also see you have set up custom thank you messages based on the highest result: 

    If you want to skip to a page instead of showing a custom thank you message then I would suggest you to check this guide: How-to-Skip-Pages-Using-Conditional-Logic

    If you have any question, let us know.