cancel
Showing results for 
Search instead for 
Did you mean: 

Sub totals in Adobe forms

Former Member
0 Kudos

HI,

I need to calculate the subtotals at the end of the page

I wrote the form calc code as

 sum(Data.Table1.Group1.Row1[*].PRICE[*]) 

but the above formula is giving the grand total.

How to get the sub total I tried as

 sum(PRICE[*]) 

but in vain.

I was unable to find the EVENTS WITH SCRIPTS in the show dropdown to do the java coding

Please help.

Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi!

make the grandtotal fielf in the layout and it should be in a one subform.

click in the field for which the grandtotal is there and then up where you can see different options like EDIT,VIEW like that BELOW THERE YOU CAN SEE : SHOW and a list box displaying events select Events with Scripts click on language as java script and RUN AT client

and add the java script code there

sum(data.Table1.Group1.Row1[].PRICE[])

this will give the grandtotal as well.

Try it will work.

Regards.