How to sum based on the selection

  • Profile Image
    youngivyacademy
    Asked on June 15, 2020 at 06:38 PM

    I have a selection like this

    A: English ($80/week)

    B: Algebra 1 ($70/week)

    C: Geometry ($70/week)

    then

    I have a weekly total. How can I sum them if any one of them (A, B, or C) is selected?

  • Profile Image
    Jovanne_A
    Answered on June 15, 2020 at 07:04 PM

    Hi, thank you for reaching out to us.

    You can make use of the Use Calculation Values in the selection and set the value of each option.

    159226202511a.png


    Then add a Form Calculation widget and set your selection field in the formula.

    159226208511b.png



    159226227811c.gif


    I hope this will help. Let us know if you have any questions.

  • Profile Image
    youngivyacademy
    Answered on June 16, 2020 at 02:07 PM

    Great!