-
Max_GordonAsked 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!
-
Yau_CReplied 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_GordonReplied on December 25, 2020 at 6:33 PMHi 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 SupportReplied 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
These aims to calculate the first columns and show the sum total on the last column.
I hope that helps.
Best.