How to apply conditions to calculate values in the input table

  • Profile Image
    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!

  • Profile Image
    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:

    Merry Christmas

  • Profile Image
    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
    Warm regards,
  • Profile Image
    Answered on December 25, 2020 at 06:49 PM

    Hi there,

    Thank you for elaborating, I believe this guide fits your requirement:


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

    I hope that helps.