Calculations are not working correctly in my Form Calculcation widgets

  • agisaude
    Perguntado em 25 de agosto de 2023 às 04:52

    Muito bom dia


    estamos a tentar inserir fórmulas e calculo num formulário, mas ele não faz o calculo.


    Formulário: WELLBEING AWARDS - AVALIAÇÃO ORGANIZACIONAL


    Obrigada

    Cátia

  • Victorino_S Jotform Support
    Respondido em 25 de agosto de 2023 às 07:11

    Hi Cátia,

    Thanks for reaching out to Jotform Support. I'm sorry you are having issues with this. Unfortunately, our Portuguese Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Portuguese, let us know, and we can have them do that. But keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. I cloned your form and tested it to see if I could replicate the issue, and I ran into the same issue. When I looked at your form, I saw that the calculations in the Form Calculation widgets weren't configured correctly, and some of the characters are set as string type and not numeric. Let me show you how to fix it: 

    1. Select the SOMA Plano estratégico field and click the Wand icon.
    2. Click the ' ( ' character to set it to a Numeric type and click Save.
      Calculations are not working correctly in my Form Calculcation widgets Image 1 Screenshot 30
    3. Then, select the Cálculo Liderança field and click the Wand icon.
    4. Click the characters that are set to String type to convert it to Numeric type and click Save.
      Calculations are not working correctly in my Form Calculcation widgets Image 2 Screenshot 41


    Can you go ahead and try it again and let us know how it goes? If the same thing happens again, we'll investigate it more to see if we can figure out what's going on.

    Let us know if you need any more help.