I feel I'm getting close - thank you to all w...

[Tammi_Canelli]

I feel I’m getting close - thank you to all who are helping, but still have issue:

I’m using this in my totals table, pulling from the registry table:

=SUM(SELECT(Medical Needs Program Registry PENDING[# dogs], TRUE=[_THISROW]))

The expression test returns the correct value - 13, but it’s not updating my sheet or the correct column # dogs.

do i need to put [_THISROW].[# dogs]

??

[Aleksi_Alkio]

SUM(SELECT(Medical Needs Program Registry PENDING[# dogs], TRUE)) should be enough.

[Tammi_Canelli]

It worked. I didn’t realize I needed to open a form view first but I came across that tip somewhere in here , tried it, and bingo! All my totals!