• Robin Mead 6
  • NEWBIE
  • 0 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
For(AggregateResult ARCY:[SELECT SUM(Amount__c) mySum, COUNT(id) myCount, Account__c
      	FROM Finance__c where Account__c =:Ac[0].id AND 
                                 (Group__c = 'TOTAL' 
                                 	OR Group__c = 'Total') AND 
                                 	(Code__c Like '%YTD%'
                                 	 OR Code__c Like :'%'+LastYear+'%'
                                 	 OR Code__c Like :'%'+Year2+'%'
                                 	 OR Code__c Like :'%'+Year3+'%'
                                 	 OR Code__c Like :'%'+Year4+'%')
                                 	GROUP BY Account__c])
               myCount = double.valueOf(ARCY.get('myCount'));
              mySum = double.valueOf(ARCY.get('mySum'));
The secont .get failes no matter what way around they are, feel like I have forgotten a limitation on AggregateResult