summing columns in repeating table - only sums first row

summing columns in repeating table - only sums first row

Post by Rick » Fri, 03 Oct 2008 06:13:50


i have created a repeating table that has a drop down to show expense
type and three subsequent columns for previous amount, change amount
and total. i have also added a footer to the repeating table to sum
each of the columns. the formula i used to autopopulate the footer
text boxes with the sum of the repeating table rows is :
sum_previous_Amount: sum(@previous_Amount). My data is linked via an
Access database.

the problem is that the function only sums the first row. any added
rows within the repeating table are not captured as part of the sum.
i followed microsoft's directions to sum the columns, so i'm at a
loss. any help would be greatly appreciated!!!

rick
 
 
 

summing columns in repeating table - only sums first row

Post by UmF2aSB » Fri, 03 Oct 2008 13:39:00

Hi Rick,

Insert formula "sum(field)" for Footer text box default value, This may
solve your problem
--
Ravi G

 
 
 

summing columns in repeating table - only sums first row

Post by U3dhdGh » Fri, 03 Oct 2008 14:35:00

Hi,
Check whether pdate this value when the result of the formula Check
box is checked or not in the footer text box properties. If it is not checked
then check this one.


--
Swathi Porandla
http://www.yqcomputer.com/




> > i have created a repeating table that has a drop down to show expense> > type and three subsequent columns for previous amount, change amount> > and total. i have also added a footer to the repeating table to sum> > each of the columns. the formula i used to autopopulate the footer> > text boxes with the sum of the repeating table rows is :> > sum_previous_Amount: sum(@previous_Amount). My data is linked via an> > Access database.> > > > the problem is that the function only sums the first row. any added> > rows within the repeating table are not captured as part of the sum.> > i followed microsoft's directions to sum the columns, so i'm at a> > loss. any help would be greatly appreciated!!!> > > > rick> >