Formel Jotform Tabelle

Hallo! ich habe ein Problem mit einer Formel in der Jotform Tabelle. Die ersten 12 Zeilen werden korrekt berechnet, ab dann ist das Ergebnis immer "0". Danke!

Hi sportkreis,

Thanks for reaching out to Jotform Support. I'd like to let you know that I am using a translation tool to provide assistance, but if you prefer to receive help in your native language, we can forward this ticket to our German Team. However, keep in mind that it could take longer to receive a response from them. 

With that said, I checked your account and I do see you have a lot of forms, and I'm not exactly sure which one is having the issue. If you can take a screenshot of what you're referring to and the form in question, that will help us take a better look at it and assist you accordingly. You can follow this guide on How to Post Screenshots to our Forum.

Once we hear back from you, we'll be able to help you with this.

The Problem ist in the blue Split "Zuschuss". From line 13 the result is "0"

Hi sportkreis, 

Thanks for getting back to us. I’m really sorry that this is happening. I am not able to confirm the form that you are referring to. Can you share with us the URL of the form with regard to your concern so that we can investigate the issue?

Once we hear back from you, we'll be able to move forward with a solution.

https://form.jotform.com/220391361568356

Hi sportkreis,

Thanks for sharing your form. I see that you're using an Advanced Formula column where you multiply 'VT anerkannt nach durchsicht' by seven. However, from the same line 13 going down, I see the data are empty, which is why the 'Zuschuss' column has 0 values in it.

I do see you have another column named ''VT anerkannt', where there are present values in all entries, so you should edit the formula and use that in the calculation instead.

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

The Formula is in the Split "Zuschuss": VT anerkannt * 7. That works 12 lines, the others not. Thera are always values on the split "VT anerkannt" in my Sheet.

Hi sportkreis,

Thanks for getting back to us. In the table, you have two columns that share almost the exact same column name, and they are:

• VT anerkannt
• VT anerkannt nach durchsicht

Currently, what you are using in the calculation is 'VT anerkannt nach durchsicht', which I've mentioned earlier has empty values from lines 13. If you can edit the formula and update it to 'VT anerkannt * 7', then that should fix the issue. Here's what I'm referring to:

Let us know if there's anything else we can help you with.

Thank you very much! I took the wrong split with a similar name in the formula. ;o)