Total refund amount by refund reason
SQL query for Salesforce
Calculate the total refund amount for each refund reason.
SELECT r.reason, SUM(r.amount) AS total_refund_amount FROM Refund r GROUP BY r.reason
Salesforce data model
Objects
Account
Account Feed
Agent Work
App Menu Item
Appointment Category
Asset
Business Brand
Buyer Group
Campaign
Case
Customer
Contact
Contract
Document
Dashboard
Folder
Group
Invoice
Inventory Reservation
Lead
Opportunity
Order
Participant
Partner
Payment
Product
Refund
Report
Return Order
Sales Store
Seller
Service Contract
Site
Skill
Solution
Task
Waitlist Participant
Work Order Line Item
Work Step History
Web Store
Work Order
Email Message
Event
Order History
Order Item History
User
User License
User Role
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed