I’m using this formula:
Payments.Filter(Project = thisRow.Project).[Payment Amount].Sum()
When I manually type in the the Project, the formula works fine
(ex: Payments.Filter(Project = ProjectA).[Payment Amount].Sum()
But when I keep “thisRow.Project” in the formula, the result is zero, no matter the project. The projects in the Payments table are lookups to the project in the table I’m using the formula in, so I’m sure the fields match. Any advice?