How to apply conditions to calculate values in the input table

  • Max_Gordon
    Asked on December 24, 2020 at 7:22 PM

    Hi there!

    I was wondering if it was possible to calculate a total in the last field seen in the image below. I would like it to add "Spring (Cooling) PM Cost") + "Fall (Heating) PM Cost" in the field of "Total Cost". I would appreciate any help in this matter.

    Thank you!

    Enjoy the holidays!

    Jotform Thread 2785538 Screenshot
  • Yau_C
    Replied on December 24, 2020 at 8:16 PM

    Hi Max,

    Yes, it can be done with our calculation widget.

    Please refer to this link for more details: https://www.jotform.com/help/343-how-to-perform-form-calculation-in-the-input-table-field

    Merry Christmas

  • Max_Gordon
    Replied on December 25, 2020 at 6:33 PM
    Hi Yau,
    I saw this online, however I’m try to have the sum on the same table rather
    than adding another part to the form. I’ll like to have it sum everything
    in the field of “Total Cost”.
    I would appreciate any help with this. Enjoy the holidays! Stay safe and
    healthy!
    Warm regards,
    Max
    ...
  • Kenneth JotForm Support
    Replied on December 25, 2020 at 6:49 PM

    Hi there,

    Thank you for elaborating, I believe this guide fits your requirement: https://www.jotform.com/help/414-calculate-values-in-the-input-table-through-condition

    1608940114 5fe67a52bdfa3 s1 Screenshot 10

    These aims to calculate the first columns and show the sum total on the last column.

    I hope that helps.

    Best.