Condition not working?

  • Artie
    Asked on September 18, 2018 at 3:49 PM

    I have four conditions giving me trouble.  

    See conditions #1, 3, 5, & 6.

    Any ideas why these conditions are not functioning properly?

    https://form.jotform.com/82524014484150 

    Thanks!

  • Mike_G JotForm Support
    Replied on September 18, 2018 at 4:29 PM

    We will be glad to help you with your concern. However, we may need to ask for more information from you so we can give you or direct you to the correct solution.

    Can you please give us the following details?

    1. What is happening right now when you test the conditions?

    2. What is not happening?

    3. What should be happening?

    If you can explain to us each calculation or the (step-by-step) process within your form, that would be great.

    We will wait for your response.

  • Artie
    Replied on September 18, 2018 at 4:47 PM

    Condition 1:  Is producing an incorrect result.

    Condition 1 Should: Produce 2019 Total Sales growth percentage by calculating (2019 total sales - 2018 totals sales)  / 2018 total sales * 100. 


    Condition 2: Is not producing anything.

    Condition 2 Should: Produce 2019 Total Sales by adding 2019 Residential Sales + 2019 Commercial Sales + 2019 ERC/Fire Sales


    Condition 5: Is producing an incorrect result.

    Condition 5 Should produce: 2019 Residential Sales growth percentage by calculating (2019 Residential Sales - 2018 Residential Sales) / 2018 Residential Sales * 100


    Condition 6: Is producing an incorrect result.

    Condition 6 Should produce: 2019 Commercial Sales growth percentage by calculating (2019 Commercial Sales - 2018 Commercial Sales) / 2018 Commercial Sales * 100


    Condition 5 & 6 should be working just like condition 4.


    Thanks!



  • Welvin Support Team Lead
    Replied on September 18, 2018 at 6:12 PM

    What's common with these conditions is the Input Masked widget. Please try cloning the form, and on the cloned form, change the Input Masked with the Single Text Entry field or Number field then re-configure the conditions. Let me know if that works. 

  • Welvin Support Team Lead
    Replied on September 18, 2018 at 6:24 PM

    I've made the suggested changes here https://form.jotform.com/82606757129969. Please check and let me know if the total is still incorrect.

  • Artie
    Replied on September 18, 2018 at 6:45 PM

    https://form.jotform.com/82606757129969


    Is Not producing any of the results I’m looking for?

  • Artie
    Replied on September 18, 2018 at 7:38 PM

    Also, I am really hoping to utilize the Input Masked widget as it is important to have the correct $ amounts with decimal placement.

  • Artie
    Replied on September 18, 2018 at 8:04 PM

    Ok, I recreated the form with no Masked Widgets.  My results are still not calculating correctly?


    https://form.jotform.com/82607816984167


    Any Help?

  • John_Benson
    Replied on September 18, 2018 at 9:46 PM

    Just for confirmation, is everything producing results now? 

    Also, if it is not calculating properly, it means there's something wrong with calculation formula. Could you please tell us some more information about your calculation formula and what you're trying to achieve? 

  • Artie
    Replied on September 19, 2018 at 7:05 AM

    Calculations are correct however, functions are not producing correctly. For instants, please look at condition number four. It works correctly. Condition five and six should be working just like condition four but they are not working correctly?

    https://form.jotform.com/82607816984167

     Thanks  

  • Kevin Support Team Lead
    Replied on September 19, 2018 at 9:13 AM

    I have been checking your conditions and it seems most of the involved elements are being conditionally calculated, note that when  this is the case all the elements involved should be filled in order to work properly. 

    Now, I would recommend you to change your formula on the condition 5 to the following:

    (2019 Residential Sales - 2018 Residential Sales) / (2018 Residential Sales * 100)

    Or 

    ((2019 Residential Sales - 2018 Residential Sales) / 2018 Residential Sales) * 100

    Using properly the hierarchy in the calculations you're performing. 

    If the calculated result is incorrect, please kindly provide us an example about how this should work, give us the values you manually use to perform the calculation so we can compare the result given by the condition.

    Looking forward to your response. 

  • Artie
    Replied on September 19, 2018 at 10:18 AM

    Still not working?

    Look at condition #1.  What am I doing wrong?


    If 2018 Residential sales = $1000

    & 2019 Residential Sales = $1500

    2019 Residential Sales Growth = 50%

    (1500-1000)/1000*100=50%


    Why is my condition #1 not working?


    Thanks!

  • Artie
    Replied on September 19, 2018 at 10:24 AM

    Never mind.  I figured it out.  I had wrong fields selected.