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?
Thank you
Views
Replies
Total Likes
In the calculate event of TotalAmount where the language is FormCalc:
sum(details.detail[*].Amount)
Kyle
Views
Replies
Total Likes
Thanks for your help
I am getting an error:
accessor 'details.detail[*].Amount is unknown.
Views
Replies
Total Likes
Also maybe something to consider abouth the error
the totalAmount field does not belong in the same subform
where the reapeting rows exists!
Views
Replies
Total Likes
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.
Example :
sum(form1.page1.details.detail[*].amount)
Vjay
Views
Replies
Total Likes
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:
sum(form1.page1.details.detail[*].amount)
Also I tried another script without success:
sum(form1.page1.details.detail[*].amount[*])
What I am missing?
Thank You
Views
Replies
Total Likes
is detail repeating row?
Vjay
Views
Replies
Total Likes
Yes, please
Views
Replies
Total Likes
You kept this
sum(form1.page1.details.detail[*].amount)
on calculate event of the amount field and Language - FormCalc?
Vjay
Views
Replies
Total Likes
Yes, calculate event and Lang. Form calc
Views
Replies
Total Likes
I tried it and its working for me.until i see the form cnt tel exact issue. Can you mail me ur form to muchukotavijay@gmail.com so that i can look into it.
Vjay
Views
Replies
Total Likes
I didnt know that you are repeating All_A subform also.
Change the script on the amount field to
sum(form1.PageA.ALL.All_A[*].details.detail[*].numAmount)
Then it works.
Vjay
Views
Replies
Total Likes
Vjay, Thank you.
WORKS!
Views
Replies
Total Likes