Estou com problemas em uma formulação de uma equação

No meu formulário [STEP 1] Formulário CASHSOL SITE, se o valor preenchido for diferente de um numero múltiplo de 100 ele e da erro na formula e da valores quebrados

Att, Livia do Grupo Ascenario

Hi Gabriel,

Thanks for reaching out to Jotform Support. 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 going back, can you explain a bit more about the issue, so I can get a better idea of what's happening? If you can share the computation you want to achieve, that'll help us to come up up with a solution.

After we hear back from you, we’ll have a better idea of what’s going on and how to help.

Vou escrever em português mas como a tradução do Google não é tão precisa, se ficar incompreensível me avise. O problema pode ser vindo de outro calculo pq são interligados. Acontece que se for preenchido por numero quebrado, o campo da falha no resultado , ele dá um número negativo. Há muitas condições no formulário, e eu ja fiz tentativas, como reorganizar as condições, substituir campos de texto curto por campo número. O calculo que eu pretendo seguir a é a economia mensal, anual, de 3 três anos e assim sucessivamente.

Att, Livia

Hi Gabriel,

I checked all the conditions in your form and noticed one condition where a string is being calculated instead of a number. Check out the screenshot below:

Is this correct, or should it be a number? If it should be a number, it’s easy to change. Let me show you how:

1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.
2. Click on Conditions on the left side of the screen.
3. Hover your mouse over the Update/Calculate Field Condition 6 and click the Pencil icon.
4. Now, click 0 to make it a number and click on Save below. That's it.

Give it a try and let us know if you need any help.

Arrumei essa parte mas ainda não foi corrigido essa parte, sempre sai negativo

Att.

Hi Gabriel,

I'll need a bit of time to look into this. I’ll get back to you as soon as I can.

Thanks for your patience, we appreciate it.

Hi Gabriel,

When I cloned and tested your form, the same thing happened for me. After investigating, I found there's an error with how the calculation result is displayed. It's showing a comma instead of a period in some fields, which is causing the result to turn negative. Check the screencast below to see my results:

To fix this, disable the current conditions and create a new one. Cloning the affected conditions won’t work. Let me walk you through it, step by step. First, show the hidden fields. We can hide them again later.

1. In Form Builder, scroll down to page 2 and select all the Number and Short Text fields.

2. Click the Hide button in the orange bar at the top-right corner of the screen.

Now, let's fix the conditions starting with DESCONTO SELECIONADO field. Since that is where the issue started. Let's do it:

1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.

2. Click Conditions on the left side of the screen, then open the All Fields dropdown on the right, just below the Add New Condition button.

3. Now, select or search DESCONTO SELECIONADO to show the conditions related to it.

4. Click the Select All box and Disable the conditions.

5. Set the conditions like you see below and click on Save.

As you can see, nothing changes in the calculation you created. We just need to redo it for this to work. Check the screenshot below to see my results:

Do the same for the rest of the fields. Then, hide the fields again. This guide will show you how to do that.

Give it a try and let us know if you need any help.