I am working on a DLRS and am not quite sure where I am going wrong. I keep getting an error on the Relationship Criteria fields. Here is the error message:
Error:
Relationship Criteria: Relationship Criteria 'MAX (cv__Amount__c)' is not valid, see SOQL documentation http://www.salesforce.com/us/developer/docs/soql_sosl/Content/sforce_api_calls_soql_select_conditionexpression.htm, error is 'unexpected token: ')''
Basically, I am trying to pull the primary (Maximum money going to it) accounting designation from a donation and have it appear on the donation record. For the where statement or Relationship Criteria - I am using:
MAX(cv_Amount__c)
And then the field in the relationship criteria fields is obviously cv_Amount__c
. However its saying that is not valid. I've tried other variations but none work.
Any suggestions?
Thanks so much in advance