Forum Discussion
Getting total percentages from text fields
I have it working to a point, but I am a little stuck as to how to show the "total percentage of completion" on the main "list" screen.
Below is my main list screen, with none of the items in the list expanded. (edited, of course)
As you can see below, I have multiple artist...54 for one, 29 for another, and so on and so on.
I am trying to get the "total" to show the percentage completed if the Stage column has data in it, on the main list view, when I close the item. Currently, the percentage shows within the list item if I expand the artist (like the below pic), but if I close it, it looks like the above image, blank.
This is what I am using now to get what I currently have.
How can I show the total percentage complete of all items from the Stage column inside my item list, like in my example above? I have 54 items under the "Unassigned" artist. If they have any of these (below) under the "Stage" column, or if they are blank and need to be filled in, I would like to have that calculated and show a percentage.
I hope this makes sense.
Thanks, Everyone, for any input you might have.
The NoobOfSP
3 Replies
Pankaj,
Thank you for the reply. This is kind of what I want, BUT I would like the percentage to be in the "Completed Percentage" column. Is this possible?
Like in your example, BUT I would like it in the Percentage column and not "grouped by" (in my case Completed Percentage column)
Also, the Power Automate part, what settings did you use to calculate this percentage from the items in your grouping?
Thanks.
Displaying Value in Percentage Column:
Group by in SharePoint does not allow selecting a specific column to display in the group header.
However, you can adjust the margins and layout using JSON formatting to visually align the group header closer to the desired column.
Power Automate Implementation:
Trigger: When an item is created or modified
Option 1: Copy the value from a calculated column into a new column.
Option 2: Use a Condition Expression to replicate the logic currently used in your calculated column.
--------------------------------------------------
If the solution provided was helpful, please consider marking it as the accepted answer.
In my opinion, using a Calculated Column may not work for this scenario.
Alternative approach:
- Create a new column, number field (e.g., "Percentage").
- Use Power Automate to populate this column whenever the Stage column changes for an item.
- Edit the list view and, under the Totals section, set the Sum option for this new column.
- Apply the following JSON formatting to the view. Be sure to replace "Percentage" with the internal name of your new column:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
"groupProps": {
"headerFormatter": {
"elmType": "div",
"style": {
"display": "flex",
"justify-content": "space-between",
"padding": "8px",
"background-color": "#f3f3f3",
"font-weight": "bold"
},
"children": [
{
"elmType": "span",
"style": {
"margin-right": "20px"
},
"txtContent": "@group.fieldData.displayValue"
},
{
"forEach": "agg in @aggregates",
"elmType": "span",
"txtContent": "= 'Total Percentage: ' + [$agg.value]"
}
]
}
}
}
