There are a lot of answers to this but I can't get the Grand Summary or Total portion to work in the formula. I'm just trying to divide 584/649 and have it display under the Total for each Suite Type not just the grand total at the very bottom. I don't really need to show the "grand total" at the bottom. I feel like I've tried every version but my current formula is:
RowCount / PARENTGROUPVAL(RowCount, Suite__c.Suite_Type__c, Suite__c.Occupied__c)
A lot of the comments mention to include Grand_Summary but I'm not sure if that is just a place holder for a field name of if that actually displays under the option dropdown which it doesn't #Reports & Dashboards #Formulas
Since you already have a Checkbox field, I would just Sum that. Checkbox values are stored as 1 or 0, and you can Sum them
Suite__c.Occupied__c:SUM / RowCount
Like this
WON:SUM / RowCount
