Summary from one table to another - should be simple!

Start Here! Coda Basics
1

Hello. I have tried several formulae to get value from one table into another but I keep getting errors.

image
image1283×438 96.9 KB

I used this formula: Copy.filter(Copy.Resource=thisRow.Resource and Copy.ResourceAugust.IsNotBlank()).Count()
and I tried this:
Copy.Filter(Copy.Resource.Contains(thisRow.Resource) and Copy.August>0
).August.Count()

I tried other options too but just cannot get it right. Please help.