Hi,
I've made a document with several tables and like to make some calculations. I already looked in the help and also in the forum. But everything that i try, won't succied. Is there anybody who can help me with this? I've made a picture to explain what my question is and also the pdf.
I hope it's clear for you what the problem is.
Greetings, Josh
Solved! Go to Solution.
Views
Replies
Total Likes
You did not have a proper sequence of rows .....I renamed them so they were sequential from Row 6 to Row37. Then updated the scripts for loop to a max value of 37.
Paul
Views
Replies
Total Likes
I was able to do all of the additions but I did not understand what you were trying to do with #4
Paul
Hi Paul,
Thanks a lot, this is half of my problem. The other problem was that i need to count al the times that "ic" was picked from the dropdown menu and al the times that "post -ic"was picked en all the times that "HC" was picked and this has to be counted in the table "huidige bedbezetting". Is this possible from a dropdown menu?
Views
Replies
Total Likes
OK ...here is a modified version. I added code to the exit event of the dropdowns (I only did the 1st 10 or so)
and what it does is cycle through each dropdown and will count the number of instances of the selcted items, then update the table. Note that
I had to rename the first couple of Rows so I could keep them in sequence (row 6-40 is what is
being added).
You only need to copy and paste the code one ach dropdowns exit event.....make sure that the language is set to Javascript (you can make it th edefault in the Form Properties).
Paul
Hi Paul,
This is exactly what i meant. Looks very good. But i tried to do what you said and copy all the script and watch if javascript was on, but my things will only give zero. What did i do wrong? The first 8 were yours, i've done the rest, but sadly not good enough. What did i miss?
What is the code for deducting, i now know what to do for making a sum?
Greetings Josh
Views
Replies
Total Likes
You did not have a proper sequence of rows .....I renamed them so they were sequential from Row 6 to Row37. Then updated the scripts for loop to a max value of 37.
Paul
Views
Replies
Total Likes
Hi Paul,
Thank you very much, sorry but i didn't understand the sequens stuff, but it looks great.
One final question; in table 4 is the sum of the totaal of table 2 and the totaal of table 3, but this has to be table 2 minus table 3. What do i have to fill in instead of sum.
Views
Replies
Total Likes
So the command woudl be:
$ = Table2.Row6.TextField7 - Table3.Row6.NumericField1
Paul
Views
Replies
Total Likes
Thanks, thats just great.
Views
Replies
Total Likes
Views
Likes
Replies