Parentgroup Value for (Sum ofShipped quantity CY2021 - Sum of Shipped Quantity CY2020)/(Shipped quantity CY2020)

Question

Hi,

I'm trying to Parentgroup value for report

Percentage%=

(Sum ofShipped quantity CY2021 - Sum of Shipped Quantity CY2020)/(Shipped quantity CY2020).

Please find the attached report screenshot with report and grouping.

Percentage should be for each rebate group and not for orderstartdate Parentgroup Value for (Sum ofShipped quantity CY2021 - Sum of Shipped Quantity CY2020)/(Shipped quantity CY2020)

Parentgroup Value for (Sum ofShipped quantity CY2021 - Sum of Shipped Quantity CY2020)/(Shipped quantity CY2020)

Any help on this would be appreciated!!

Thanks in Advance!!

Regards,

Saranya K

Abhinav Thakur · Answer

Hi Saranya,

You can refer below doc :

https://developer.salesforce.com/docs/atlas.en-us.salesforce_report_summary_functions_cheatsheet.meta/salesforce_report_summary_functions_cheatsheet/reports_summary_functions_about.htm

https://salesforce.stackexchange.com/questions/245413/parentgroupval-to-calculate-amount-percentage-in-reports

Thanks!

Parentgroup Value for (Sum ofShipped quantity CY2021 - Sum of Shipped Quantity CY2020)/(Shipped quantity CY2020)

Lightning Experience

Formation associée

Aide supplémentaire