You need to sign in to do that
Don't have an account?
Yuki Tan
how to sum a formula column in report?
Hi.
I have a report to sum sales group by month. And i have a formula column which is current month total sales divide by last month sales.
Now i wanna sum they. How can i do that?
This is my report.
My formula column is :
Case2__c.price__c:SUM/PREVGROUPVAL(Case2__c.price__c:SUM, Case2__c.Complete_Date__c,1)
I have a report to sum sales group by month. And i have a formula column which is current month total sales divide by last month sales.
Now i wanna sum they. How can i do that?
This is my report.
My formula column is :
Case2__c.price__c:SUM/PREVGROUPVAL(Case2__c.price__c:SUM, Case2__c.Complete_Date__c,1)
The below trailhead module might answer the query,
https://trailhead.salesforce.com/en/content/learn/projects/create-reports-and-dashboards-for-sales-and-marketing-managers/use-summary-formulas-in-your-reports
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks.