-
shujunAsked 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.
-
BJoannaReplied 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.
-
shujunReplied on February 20, 2019 at 8:43 PMHi,
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
... -
shujunReplied on February 20, 2019 at 8:43 PMhi,
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
... -
shujunReplied on February 20, 2019 at 8:43 PMhi
I have found out what i am trying to do.
Thank you for your time.
...