I wouldn’t mind some help on the calculation aspects

  • Profile Image
    isbitt
    Asked on September 14, 2015 at 02:03 PM
    I wouldn’t mind some help on the calculation aspects
    Im looking for a user to enter a value, say £1000 and the form provides the gross figure including 20% VAT alongside it.
    So 1000 entered and a ‘greyed out’ box alongside it shows ‘1200’ as it includes the 20% VAT
    Is this possible, and what option so I select ?
    Many thanks
  • Profile Image
    david
    Answered on September 14, 2015 at 02:11 PM

    Hi,

    For calculations in your form, you can use a calculation widget:

    http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    Then setup your calculation to take the number entered, multiply it by the tax, then add it back to the original number:

    This will give you the total plus tax.

    Here is a quick copy of your form with the calculation added:

    http://form.jotformpro.com/form/52565863321962

    You can clone it to your account if you would like:

    http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    If you have any further questions, let us know and we will be happy to help.

  • Profile Image
    isbitt
    Answered on September 16, 2015 at 04:47 AM
    Morning
    Thanks very much for this, very helpful and opens a lot of possibilities
    Thanks
    ----------------------------------------------------------
    Richard Isbitt
    Group Contract Billing & Customer Data Manager
    SThree Plc
    1st Floor, 75 King William Street, London,EC4N 7BE, UK
    ----------------------------------------------------------
    •: +44 (0) 207 264 3573
    • Internal 246 7573
    •:: mailto:r.isbitt@sthree.com
    •: www.sthree.co.uk
    ----------------------------------------------------------
    ...
  • Profile Image
    isbitt
    Answered on November 16, 2015 at 07:46 AM
    Hi there
    Thanks for your help,
    I would appreciate your help with this one
    When the user selects a reason code “Bill Rate” the below 3 boxes show up. This works on the conditions section which is great
    [cid:image007.jpg@01D1206B.F9213E70]
    However im trying to calculate the net loss/gain based on the formula (New rate – Old rate) * Total Days / Hours
    When I try to create it via the add field section I can’t see to separate these 3 fields and it looks at each one collectively. Could you help?
    [cid:image008.jpg@01D1206B.F9213E70]
    [cid:image009.jpg@01D1206B.F9213E70]
    Thanks

    ----------------------------------------------------------
    Richard Isbitt
    Group Contract Billing & Customer Data Manager
    SThree Plc
    1st Floor, 75 King William Street, London,EC4N 7BE, UK
    ----------------------------------------------------------
    •: +44 (0) 207 264 3573
    • Internal 246 7573
    •:: mailto:r.isbitt@sthree.com
    •: www.sthree.co.uk
    ----------------------------------------------------------
    ...
  • Profile Image
    beril
    Answered on November 16, 2015 at 10:17 AM

    I've created a separate thread for you, so anyone in the support staff will be able to assist you with your specific requirement. Please follow up there:

    http://www.jotform.com/answers/705560