My table name is details
the repeating row name is detail
the column name is Amount
I have a separate numeric field (does not included in the table) with the name TotalAmount
How I will calculate the Amount of the repeting rows for the TotalAmount field?
This might be because of the path which you specified in the Sum(***) function.
Click on amount field and copy the whole path and put it in Sum function.
Thank you Vjay!
One step ahead..
I use your script,does not genarate any error and give me the amount os the first(default) row.
But when I add another instance the amount remain the same(as first row).
I am using the script:
Also I tried another script without success:
What I am missing?
I didnt know that you are repeating All_A subform also.
Change the script on the amount field to
Then it works.