How to add up cells/rows on form?

  • grandlake4422
    Asked on November 2, 2021 at 2:57 PM

    I just converted a form not too long ago and the last page has an expense column and total revenue and total expenses. How can I have all the cells add up and show on the total line expense?

    Here is the link to the form and its the last page where all the cells are input by dollar amount and what I want to do is have the total revenue and total expenses add the dollar amount on all lines together: https://form.jotform.com/211465299819064



    Jotform Thread 3477226 Screenshot
    Page URL: https://form.jotform.com/211465299819064
  • Saeed Support Team Lead
    Replied on November 2, 2021 at 4:13 PM

    Hi there,

    Thank you reaching support!

    You can achieve this by using Conditional Logic. I have explained it in screenshot given below:

    1635883525 61819a055e093 Screenshot 10

    I hope that explains it. Please contact us again if we can help in any way.

  • grandlake4422
    Replied on November 2, 2021 at 7:44 PM

    Thank you, that worked! I must have done this months ago for which I see that I have some conditions already defined. I have one more question.

    On the revenue/expense page, how can I show the dollar sign and decimal value? When someone fills out the form, I would like it to read as $5.00 and not just the number 5.
    Thanks in advance, you rock! Jeanette
  • Sweta JotForm Support
    Replied on November 2, 2021 at 9:17 PM

    Greetings Jeanette!

    We have moved your second query to a separate ticket:

    https://www.jotform.com/answers/3478130

    Please allow us some time to check and get back to you.

    Thanks.