Sum filtered items in repeating group

Hello,
In my CRM App I have a repeating group of Deals. Each Deal has an Expected Value and Stage (among other things). I have an input field that displays the sum of all of the expected deal values. This works great. I also have a dropdown to filter the deals by their stage. This also works great.

What I can’t find a way to do is to display the sum of the filtered deals. When I filter the deals by a stage the Sum still shows the total of all deals.

Any help would be appreciated.
Thanks…

The input field won’t update when you change the filter. Use a text element instead.

1 Like

That worked. Thank you so much!!!

1 Like

Hi, how did u set up the sum of the values?

thanks a lot!

1 Like

Hey SerPounce,

I used a text element on a repeating group with editable inputs and plugged in this formula: Search for “entries which contain the values I am looking to sum” :each item’s “values I am looking to sum” :filtered :sum.

When I filter between two dates, the text element’s sum remains the total… What am I doing wrong? Thanks!