Dynamically Calculated Column doesn't support aggregate expr

[JonP]

I tried to count the number of relationships for a peer multiple attribute, which resulted in an error, "Invalid calculation: Syntax error at token '.' (column 2)." The error results from only the expression. Leaving the expression off technically works, but the column cell is empty rather than showing 'No' when there are no relationships, so I need COUNT() to get the 0 that will give me a 'No'. Changing the type has no effect either. The problem is the aggregate expression.

[aware_support]

If pm_EnterpriseConsiderationSurveys is a multiple reference, then you cannot use it in COUNT like this.

The correct syntax is something along the lines of:

COUNT EnterpriseConsiderationSurvey WHERE (EnterpriseConsiderationSurvey IN Person.pm...)

[JonP]

I tried as you suggested, but I got another error: "Aggregate functions in calculation may not have WHERE keyword".