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

expressions
(Tammi Canelli) #1

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) #2

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

(Tammi Canelli) #3

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!