How to perform calculation in the Input Table field?

  • shujun
    Asked on February 20, 2019 at 1:55 AM

    hi

    i am currently doing a form like this:

    Products Daily Sales Price (RM) Total sales Commission (%) Total commission (RM)

    A 9 9.4 84.6 5% 4.23

    B 5 10 50 3% 1.5

    C 10 5 50 3% 1.5

    7.23

    i just able to set the formula for the 1st row, but i have no idea how to set the formula for the remaining rows, Is it able to set the formula of the auto calculation for each row?

    Thank you.

  • BJoanna
    Replied on February 20, 2019 at 2:50 AM

    Are you working on this form - https://www.jotform.me/form/90488639801467

    Do you want to perform a calculation in the Input Table (Matrix) field? If so, please check the following guide:

    How to Perform Form Calculation in the Matrix Field?

    If you still have difficulties to set the calculation, please explain in more details what exactly are you trying to achieve and which (Input Table) fields should be included in the calculation formula. 

  • shujun
    Replied on February 20, 2019 at 8:43 PM
    Hi,
    Thank you for the prompt reply.
    Actually i have referred to the link that you sent it to me. Yet, i cant
    get what i really want.
    Yes, i am working on this form, https://form.jotform.me/90488639801467. The
    calculation that i m trying to achieve is to set all the auto calculation
    in each row, but i m only able to set on the first row. You can see from
    the form that i am working on it (https://form.jotform.me/90488639801467)
    that i have done the form calculation for the first row which is the total
    sales and total commission. The problem i am facing is that how can i set
    the form calculation for the remaining row 2 and row 3?
    Thank you.
    Regards,
    Shu Jun
    ...
  • shujun
    Replied on February 20, 2019 at 8:43 PM
    hi,
    According to the problem i am facing, is it when i want to create an auto
    calculation formula for an answer, i need to create a new form calculation?
    Like the one i am working on it, for the first row, i need 2 calculations
    which are total sales and total commission, so need to create 2 form
    calculation. And for row 2, i need 2 calculation which are total sales and
    total commission, need to create another 2 form calculation ?
    Thank you.
    Regards,
    Shu Jun
    ...
  • shujun
    Replied on February 20, 2019 at 8:43 PM
    hi
    I have found out what i am trying to do.
    Thank you for your time.
    ...