I need to sum a column that has a filter on a repeating table. I know how to do it but I get the sum of all the rows instead of the filtered ones. Is there a way to sum a column that has filter on a repeating table?
Add the same filter to your sum function.
So sum(field1[Field2 = X]) as an example
Clay- I need to sum a few columns in my filtered repeating table. How would would you write the sum function if there are two filters on the data? I am using http://www.bizsupportonline.net/infopath2003/filter-repeating-table-date-range-rules.htm (see steps 14-22). I am using this procedure in my repeating table. Thanks. RhysAZ
I figured it out.