Wrong calculation output.

  • b.m.ezzat
    Asked on November 16, 2016 at 6:05 AM

    Dears 

    In the below field called 'pastries' with ID {pastries}, i defined it to have the sum of only the below drop down menus

    Wrong calculation output Screenshot 30

     

    However when i add any item in pastas drop down menu i see it gives wrong values, when i add any item from below please check

    Wrong calculation output Screenshot 41

  • omerorkun JotForm Data Scientist
    Replied on November 16, 2016 at 8:11 AM

    Hi,

    As far as I have understood you just want to calculate the number of pastries in the "pastries" field below. However, when you assign calculation values for the dropdown field in the surveying tab it no longer gives the number output. 

    I mean you want the total quantity, however quantity values are assigned to the prices by in-field calculation values:

    Wrong calculation output Screenshot 20

    These are the assigned values for quantities. 1 corresponds to 140, 2 corresponds to 280 and etc. If you want the prices to be calculated tough, it is already successfully configured. 

    Please let me know if I have misunderstood the issue.

    For the second screenshot you attached I could not see what the issue is. Please provide us further clarifications so that we can investigate the issue better.

    We will be waiting for your update. 

    Thank you for contacting us. 

  • b.m.ezzat
    Replied on November 17, 2016 at 7:13 AM

    Hi Owen

    No you didnt get me well

    Let me clarify again

    i want to calculate the price of pasteries which i set in the drop down menu as you highlighted above if 1 pirces is 140 if 2 price is 280 and so on, it work well if i choose from the items of pasteries but if i make any changes in the soups  after i choose the pasteries (drop down menus above) i found that the value is changed to sum of soups and not pasteries as hown below, output should be 420 however i get 90 which is equal to the two items chosen from soups

    Wrong calculation output Screenshot 20

     

  • Chriistian Jotform Support
    Replied on November 17, 2016 at 10:43 AM

    Hi there,

    I looked at the calculation of your field "pastries".

    Wrong calculation output Screenshot 40

     

    It seems to be adding all the values from the fields under "soup".

    Wrong calculation output Screenshot 51

     

    To correct the result, please change the calculation as shown below.

    Wrong calculation output Screenshot 62

    Let us know if you need further assistance.

     

  • b.m.ezzat
    Replied on November 18, 2016 at 1:42 AM

     No i didnt do that

    Beside its updated with the values of pasteries whenever i choose any item from pasteries but porblem if i update any item from soup it will be change to soup values

    Please tell me how did you get the screen as from my side it appears as below

     

     

    Wrong calculation output Screenshot 20

     

    Please note that i delete it again and added it back and still same problem

    i even deleted it now and put it as condition and still same issue

  • Chriistian Jotform Support
    Replied on November 18, 2016 at 2:04 AM

    I see that you changed the Pastries total from a Calculation into a Condition. I checked the field and it seems like this has resolved the issue.

    Wrong calculation output Screenshot 30

    I chose an item from the Pastries, then I updated an item from the Soup field. The Pastries total value remains the same no matter how many times I updated the Soup field.

    Wrong calculation output Screenshot 41

    Can you please check again and confirm if this is the expected behavior that you want to happen in the form?

    Please note that the Calculations Wizard that you see on your end is the new design of the Calculation wizard. My calculation wizard is still on the old design version, so it is different from yours.

    I will wait for your response.
    Thank you.

     

     

  • b.m.ezzat
    Replied on November 18, 2016 at 3:40 AM

    No not solved as per below snapshot it still gives sum of soups if i changed the soups values after adding the pasteries

    however it will give you snapshot if i edited back the pasteries

    Wrong calculation output Screenshot 20

     

  • Boris
    Replied on November 18, 2016 at 6:05 AM

    I have checked the form you have linked to ( https://form.myjotform.com/61097134175556 ) with the reproduction steps that were provided, and same as my colleagues the calculation field appears to show only the value based on selected pastries, and not the soups.

    Here is a screen recording of the form and its calculation:

    Wrong calculation output Screenshot 20

    From my understanding, these are the steps you have mentioned, and the form appears to be working fine in calculating the pastries and omitting the soups.

    Can you please opening your form's direct link in a private or incognito window of your browser, and try checking then. I would also recommend testing with a different browser as well. Please let us know how it goes.