How to apply conditions to calculate values in the input table

  • Profile Image
    Max_Gordon
    Asked on December 24, 2020 at 07: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!

    Screenshot
  • Profile Image
    Yau
    Answered on December 24, 2020 at 08: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

  • Profile Image
    Max_Gordon
    Answered on December 25, 2020 at 06: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
    ...
  • Profile Image
    Kenneth
    Answered on December 25, 2020 at 06: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.gif

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

    I hope that helps.

    Best.