I am trying to build a query that references a value within a record's own row. In Excel this is super simple- the CountIF statement would look like this:
Referencing a field seems pretty easy; it's referencing the value of said field in the current row that I am struggling with. I feel like it is a very simple syntax thing. Ideas?Code:COUNTIF([Field1],[@Field1],[Field2],[@Field2]...)