# What % each grouping represent in an aggregate model

Dave
Member ✭✭

Hi,

I'm sure this is possible with a simple solution, but for some reason my brain won't work properly today

I have an aggregate model, and there's a grouping on it (field: status)

I want to find a way to show what % of grand total each 'group' represents

So as per example SS below , there's a total of 73 records

and i want each line (or group) to show % of grand total (73) it represents

So 1st line (approved) would show 48% ...

Any simple way to accomplish this?

Thank you

I'm sure this is possible with a simple solution, but for some reason my brain won't work properly today

I have an aggregate model, and there's a grouping on it (field: status)

I want to find a way to show what % of grand total each 'group' represents

So as per example SS below , there's a total of 73 records

and i want each line (or group) to show % of grand total (73) it represents

So 1st line (approved) would show 48% ...

Any simple way to accomplish this?

Thank you

1

## Comments

I was able to build this pretty simply:

I made two models.

The first model was an aggregate counting the sum total of the albums.

The second model was an aggregate counting the sum total of the albums grouped together by Genre Name.

Then I created a UI Only field on the second model that used global merge syntax in a formula field to pull the '60' album count. The formula was pretty simple. I'm fairly certain there are other ways that could accomplish this, but I like this one.

Thanks for bringing this up. Let me know if you have any questions on the build.

Maybe add + '%' to the end in order for it to look extra purdy.

Thank you very much will test it shortly

Here is a quick pic of the scenario and the formula I am using with the two aggregate models...

The problem here is that you need a different total for each month. I'm guessing your TestForSquidTotal model is just getting the total all the data, not the total for each month? Or if it is getting month, you're only getting the first month (row 0).