How do I multiple a decimal number with input table?

  • Profile Image
    marketing02
    Asked on June 28, 2021 at 03:37 AM

    Hi, I've tried to calculate, but cant get the right calculation.

    The amount reflected in Subtotal Amt w/o GST is the total of summed fields.

    Please assist to advice.


  • Profile Image
    gerardw
    Answered on June 28, 2021 at 06:43 AM

    With respect to the current conditional calculation, the total is shown correctly on the input table:

    1624876813_60d9a70d0e35a_2806_3.png

    Is item each valued at $2.50?

    Then you will need to add () in the calculation as shown:

    1624876932_60d9a784b346f_2806_4.png

    Please check and let us know.

  • Profile Image
    marketing02
    Answered on June 28, 2021 at 10:16 PM

    Yes, it does work. Tq so much.

    But may I bother u again, if I use the Form Calculation to calculate GST using below calculation will it be possible? as of now, I've tried but no calculation done.

    Or do I need to is the condition to do the calculation?

    1624932982_60da8276726a9_Form Calculatio

  • Profile Image
    gerardw
    Answered on June 28, 2021 at 11:31 PM

    You can also use the widget instead of conditions to calculate.

    Replace 7% with 0.07 and check:

    1624937493_60da941509a3a_2906_1.png

    Do check and let us know.

  • Profile Image
    marketing02
    Answered on June 29, 2021 at 12:43 AM

    Yes. It really work. Tq so much.

    Btw, I send a new support request. Please assist.

  • Profile Image
    gerardw
    Answered on June 29, 2021 at 03:01 AM

    Sure we will address that on your logged ticket directly: https://www.jotform.com/answers/3188075