I want to write a query that will return multiply of two fields. Is it possible?
// Aggregate Query to collect Sum of all Combinations of Brand Name and Reporting Groups. List<AggregateResult> arrAllDaysCRsResult = [SELECT Sum(Relative_Date_Calculated__c) totalRewards, Brand_Name__c, Reporting_Group__c, Contractor__c FROM Contractor_Rewards__c WHERE Brand_Name_Calculated__c in:brandNameSet AND Contractor__c in:contactsMap.keyset() // AND Reporting_Group__c in:reportingGroupSet group by Brand_Name__c, Reporting_Group__c, Contractor__c ];
here is my soql query and i want