select sum(Transaction_Allocation__c.Amount__c) amount, count(Transaction_Allocation__c.Amount__c) The_Count, Opportunity__r.CiWF_Payment_Method__c, Opportunity__r.Country_of_Ownership__c, Opportunity__r.CurrencyIsoCode, CALENDAR_MONTH(Transaction_Allocation__c.Close_Date__c) Months, CALENDAR_YEAR(Transaction_Allocation__c.Close_Date__c) Years from Transaction_Allocation__c where (Transaction_Allocation__c.Close_Date__c > 2022-03-31 AND Transaction_Allocation__c.Close_Date__c < NEXT_N_DAYS:1) AND (Transaction_Allocation__c.Stage__c IN ('Posted','Refunded','Failed','Refund','Reversal') AND Opportunity__r.RecordTypeId IN ('012w0000000MQol','012w0000000hbgn') AND Transaction_Allocation__c.TA_GL_Category__c = 'Appeal (50050)' ) Group by Opportunity__r.CiWF_Payment_Method__c, Opportunity__r.Country_of_Ownership__c,Opportunity__r.CurrencyIsoCode, CALENDAR_MONTH(Transaction_Allocation__c.Close_Date__c),CALENDAR_YEAR(Transaction_Allocation__c.Close_Date__c)
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter