You need to sign in to do that
Don't have an account?
Kolli
How to get Next Group record count in summary report
Hi All,
I am creating one opportunity report that will show the percentage to complete the next stage. And the report is having group by Stage field.
Formula - (Next stage record count/Current stage record count)*100.
I tried with existing function “PREVGROUPVAL” working fine but it’s not suitable for my requirement. However do we have the same kind function or any solution to get Next Group Value (means Next stage record count). Anyone who has worked related to such issue can expedite their help.
Regards,
Ragavendr Kolli
I am creating one opportunity report that will show the percentage to complete the next stage. And the report is having group by Stage field.
Formula - (Next stage record count/Current stage record count)*100.
I tried with existing function “PREVGROUPVAL” working fine but it’s not suitable for my requirement. However do we have the same kind function or any solution to get Next Group Value (means Next stage record count). Anyone who has worked related to such issue can expedite their help.
Regards,
Ragavendr Kolli
When you want to know sum, average, highest, or lowest value of a numeric column (like Amount, Age, or Probability), summarize the column. Summaries calculate subtotals for every group in a report, as well as a grand total for all report data. More information is here; https://help.salesforce.com/s/articleView?id=sf.reports_builder_fields_summaries.htm&type=5
Thanks,
https://www.foremostpayonline.org/
Please refer to the below mentioned links for your requirement -
1. https://salesforce.stackexchange.com/questions/347068/calculate-percentage
2. https://salesforce.stackexchange.com/questions/136205/percentage-of-from-stage-record-count-in-salesforce-opportunity-history-matrix-r
3. https://www.youtube.com/watch?v=JOlUfCw-lhg
Hope it Helps !
Thank you .