Can i add a formula which would calculate a total price?

  • Profile Image
    Jenna Ray 
    Asked on December 16, 2015 at 02:26 PM

    If users enter 1, 2, or 3 parcels in my form, I would like to have a formula which will generate the total price for their "order". Say 2X$4USDX1.39 for Canadian Funds. 

  • Profile Image
    victor
    Answered on December 16, 2015 at 03:05 PM

    Yes, you can accomplish this by creating a UPDATE VALUE condition

    Once the users enters a value and selects the type of currency. This will be calculated and be placed in the result field.

    Please let us know if this helps.

  • Profile Image
    Jenna 
    Answered on December 16, 2015 at 03:34 PM

    its very handy indeed EXCEPT that the decimal doesn't seem to work. It looks like it does but once saved the decimal disappears and then calculates as a whole number. Instead of 1.39 is uses 139

  • Profile Image
    BJoanna
    Answered on December 16, 2015 at 04:10 PM

    I was able to replicate mentioned issue when I created condition, on my demo form, 1.39 was changed to 139. 

    I was able to fix it by clicking on condition for that field and then changing value to 1.39.

    Here is my demo form: https://form.jotform.com/53495837392974? 

    Feel free to clone it.

    Hope this will help. Let us know if you need further assistance.