Conditional Summation in a Repeating Table

[Jane]

Hi Folks,
I have a repeating table that has numberical columns. I put a footer in the
table and the columns are summed up nicely.

I created additional views where I filter the table - I take out rows that
don't meet the filter. The columns are still summing, but they show the
total, as if no data was removed.

Question - How can I get the sums in the colums of the repeating table to
sum only the data that is in the table after it has been filtered? Thanks!!!

If there is a better way to do this - combine numerical data, with
conditions, I'd sure love to hear that too. Thanks!

 

[Shiva (GGK Tech)]

Hello,

If your filter condition field also in the same level of repeating section
then we can add filter condition like this below,
sum(field1[field2 != ‘ConditionValue’])