How to do a greater than calculation

  • Profile Image
    kg87
    Asked on February 03, 2017 at 07:17 AM

    Hi,

    I'm trying to do quite a complex calculation for an events catering company. They want a calculation that works out a quote depending on the no. of people multiplied by the menu option.

    The quote would work out that if you entered a number between the variables below then a percentage would be added or discounted to the order.

    No. of people 0-200 (0%), 201 - 399 (-10%), 400 -599 (-20%), 600+ (+25%) x

    There are 3 menu options

    £11.95 inc Vat 

    £14.55 inc Vat 

     

    £16.50 inc Vat

     

    Thanks in advance!

     

  • Profile Image
    EltonCris
    Answered on February 03, 2017 at 08:09 AM

    Is this related to your question on the other thread here? My colleague has replied to it.

    https://www.jotform.com/answers/1054641

    To do greater than conditions, you will have to use a number field or calculation field as the trigger point. I checked your form and I think you've already figured this out.

    --

    Base on your description, I don't think you will need the party size field. You can do it like the following.

    Hope this helps