---
schema_version: "1"
id: 2c828a771b1c56b59b129fe75d8fdffaae6892b44fa39075932d5034d5e83463
title: PARENTGROUPVAL
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/customize_functions_parentgroupval.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.customize_functions_parentgroupval.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 4336dd5d7ae3c7ed885abadf5373708817ae386c7b8f0152338e5b84dd67803c
description: This function returns the value of a specified parent grouping. A “parent” grouping is any level above the one containing the formula.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# PARENTGROUPVAL

This function returns the value of a specified parent grouping. A “parent” grouping is any level above the one containing the formula.

You can use this function only in custom summary formulas and at grouping levels for reports, but not at summary levels.

## Use

- Summary and Joined:
    
    `PARENTGROUPVAL(summary_field, grouping_level)`
- Matrix:
    
    `PARENTGROUPVAL(summary_field, parent_row_grouping, parent_column_grouping)`

Where `summary_field` is the summarized field value, `grouping_level` is `GRAND_SUMMARY` or the API name of the parent level group for summary reports, and `parent_row_level` and `parent_column_level` are the parent levels for matrix reports.

In reports with multiple grouping levels, you can set the `grouping_level` to be any group level higher than the formula display level.

![Formula Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_example.png)

Formula Example

```
TOTAL_PRICE:SUM/PARENTGROUPVAL(TOTAL_PRICE:SUM, GRAND_SUMMARY)
```

This formula calculates, for each product, its relative size compared to the grand total. In this example, the report is a summary of opportunities and their products, grouped by Product Name.