CS Report Builder - Percentages on Aggregated fields

Hey Folks ,

I’m a newcomer to Gainsight, and after completing the Associate Admin training for CS I’m looking to understand a bit more about the capabilities in Report builder.

We have an Object with a field that can contain a value of true or false. Multiple records in the object can are associated with each company.

Ideally, we’re looking to create a Report that shows the % of false records per account, versus the total number of records for the account.

Currently, I’ve used a combination of filtering on the true/false field, and aggregation to make a COUNT of the false records.  The roadblock I’m encountering is converting the COUNT value for each Account into a percentage of the total # records for each Account.

My inital thought was to use a formula field, however from what I understand this would only work on a record-level, creating a new field on each record, as opposed to being able to compute on the ‘roll-up’ COUNT values.

I’ve checked the Knowledge Articles Advanced Report Settings (Horizon Analytics), Formula Fields in Reporting and had a look on the Community; I found the post {Posting for a customer}- Ability to use column calculations to determine percentages in Report builder, however this appears to be requested functionality, and using segmentation in Adoption Explorer, which doesn’t apply to our use case.

I’ve put in a ticket with Support, but I also wanted to reach out to the community to ask if this is something other Admins are familiar with/have come across before, and any potential solutions.

Any guidance is greatly appreciated.

Thanks!