I need discount percentages based on the number of selected Shows

  • Profile Image
    TNNY
    Asked on February 01, 2020 at 02:26 PM

    HI,

    I need to add total based on:

    Please select the musical titles in which your are licensing and Total Number of Performances:

    However, I'd like to add a discount percentage based on the number of shows and performances.

    See my rates below:

     

           

    Rate

    Discount

    (For Performance Royalties)

    Royalty

    (Discount Applied)

    Every

    Additional Performance

    (Discount Applied)

           

    1 Show

     

    $50

    $40

           

    2 Shows

    10% Off

    $90

    $72

           

    3 Shows

    10% Off

    $135

    $108

           

    4 Shows

    10% Off

    $180

    $144

           

    5 Shows

    15% Off

    $212.50

    $170

           

    6 Shows

    15% Off

    $255

    $204

           

    7 Shows

    15% Off

    $297.50

    $238

           

    8 Shows

    20% Off

    $320

    $256

           

    9 Shows

    20% Off

    $360

    $288

           

    10 Shows

    20% Off

    $400

    $320

    As you see per title they chose the value changes as well as the number of additional performances. (One royalty = 1 performance) Then are two discounts for every additional performance $10 off and then a % off based on the number of titles they selected. 

     

  • Profile Image
    Mike_G
    Answered on February 01, 2020 at 06:48 PM

    We will be glad to help you with your concern. However, so we can provide you with the best solution, we would need to confirm from you first if we understand your concern correctly.

    From what I understand, a show costs $50. And, for every additional show, a specific discount will be applied.

    1580600360zt18_38_54.png

    Also, to my understanding, each show will have performances, and for each additional performance added to the show, there is a specific discounted rate.

    Can you tell us how would you like to represent each show and each performance on the form, please?

    Are shows listed on a Multiple Choice field as options? How about performances?

    Or, do you like your respondents to enter a number in a field?

    I believe we can do this with our forms using either conditions or the calculation widget or both.

    http://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-field-using-a-Condition

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    We will wait for your response.

  • Profile Image
    TNNY
    Answered on February 02, 2020 at 04:05 PM

    "From what I understand, a show costs $50. And, for every additional show, a specific discount will be applied."- Yes that is correctAre shows listed on a Multiple Choice field as options? - Yes that is correct see below as listed in the form - "Please select the musical titles in which your are licensing":

    "How about performances?" - Currently it's in input field. 

    To clarify, when one show is selected, it's counted as the first performance. Then a person would need to let us know if they were doing more than one performance. Depending on the number of shows they selected define the the amount of discounts;

    1580677429Screen Shot 2020-02-02 at 3.59

  • Profile Image
    AshtonP
    Answered on February 02, 2020 at 05:38 PM

    Thanks for clarifying further.

    As per the requirement, I have created one sample form. Here's the screencast:

    158068293711.gif

    Please check is this what you are looking for. Following is the form link:

    https://form.jotform.com/200326577019049

    You can clone this form using this guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Let us know if you need any changes to this. We will be glad to help you out.

    Wating for your response.

  • Profile Image
    TNNY
    Answered on February 03, 2020 at 02:29 PM

    Hi Ashton,

    Close. But, it's possible for someone to select one show and opt to have many performances of that one show. the example above looks like they are only be asked if they or doing 1 or two performances. 

    So I'm wondering if it would be easier to establish the base rate of $50 per show/1st performance and $40 for every additional performance.

    Then based on the number of musicals titles/shows they've selected the the total is discounted. 

    For ex: I select FOUR shows. and communicate that I'll be doing 4 additional performances. for a total of 5 performances. So the Base rate of $200 (as I select four different shows at $50 each) then $160 for four the additional performances for four shows. The total before the discount is $360.

    However then in the next field it shows the discount of 10% off since i had selected four shows. (Which could be more if I had select a different amount of titles.)


    Then the last field is the grand total with discount applied. something like:

    (for four shows with four additional performances)

    Total of Royalty/first perfromance per show: $200

    Total of additional performances per show: $160

    Discount (based on the number of shows selected):  -$36

    grand total of: $324


    Does that make sense? Thanks for your help

  • Profile Image
    Kevin_G
    Answered on February 03, 2020 at 08:06 PM

    It's indeed possible to allow users to add as many additional shows as they want, you simply need to add a number field to your form and then include this field on the calculations, note that you will need to edit each condition where you're discounting the corresponding percentage to the total. 

    Here are some examples about how the calculations should be: 

    1. When the user selects 1 show, as it does not have discount this will only sum the total:

    15807777222020-02-03_18h55_07.png

    2. When user selects 2 shows and wants additional performances then the calculation needs to be like this: 

    15807782582020-02-03_19h02_14.png

    The highlighted numbers will be the only ones to change, the ones in yellow are the sum for the first show and additional performances, the one in red is the percentage you will be discounting, make sure to set the calculation exactly as it's shown on the screenshot, missing a parenthesis or adding an additional symbol will break the calculation. 

    Here's my sample form: https://form.jotform.com/200337669662966 

    You can clone it and inspect what I have changed. 

    If you have questions, let us know.

  • Profile Image
    TNNY
    Answered on February 04, 2020 at 03:32 PM

    Hi - So it seems I'm good to go with it comes to someone selecting the number of of shows "musicals" with NO additional performances. However, the formula is still not showing correct math to reflect my discount structure.

    Here are the rates without and with the discounts. 

    1580847650Screen Shot 2020-02-04 at 3.18

    Using the example -  3 shows with 2 additional performances, with the discount applied the total should be: $351

    based on your form the total is: $108 which is incorrect.


    Also Note: I've updated my form to reflect the fields you've create. Going up to 10 shows instead of 4) https://form.jotform.com/TNNY/licensing-contracts--payments


    1580847797Screen Shot 2020-02-04 at 3.22



  • Profile Image
    Kevin_G
    Answered on February 04, 2020 at 05:06 PM

    My sample form only has configured the two first options as the logic is the same for the rest, I would recommend you to kindly try implementing the formula and logic to your form in order to see how it works, once you get it working with one option you may follow with the next one and move on once you've confirmed it works. 

    Now, on my form you may try the following example: 

    1. Select 2 Show and add 2 additional shows, the result should be $210.60 since we have $90 as price show and $72 for additional performances, if the price is $100 per show and $80 for additional performance you may simply update the condition to reflect the prices. 

    If you have questions, let us know. 

  • Profile Image
    TNNY
    Answered on February 04, 2020 at 05:23 PM

    Hi Kevin, 

    The payment breakdown I provided you had already included the discount in the totals. So it seems that your formula is adding an additional discount. 

    I'll play around with it and let you know if I have more questions. Thanks for your help so far. 

  • Profile Image
    Kevin_G
    Answered on February 04, 2020 at 06:50 PM

    The payment breakdown I provided you had already included the discount in the totals. So it seems that your formula is adding an additional discount. 

    Yes, my formula includes the prices with the discount already, if you would prefer, you may replace those prices with the ones without discount and then have the total calculated with the new values. 

    Let us know if you have questions.