Jump to content
We've recently updated our Privacy Statement, available here ×

How to calculate a percentage based on group?


nizam27391

Recommended Posts

Hi all,

I have this problem of calculating percentage for each row based on the total of faculty which ends as group.

jasper-percentage(1).PNG.d141337d2aeb47c8ed21a5fd3ce08afc.PNG

As you can see above,

the blue - number of each row

the red  - total for each faculty

the black - the percentage i'm trying to calculate

 

Now what I want to do is to calculate the percentage for each row based on the faculty, the formula to get the percentage will be 

black = (blue/red)*100

 

I've try working on calculate when group faculty ends. But the value is incorrect as it get the final value of blue.

 

Please help me with this.

Thanks

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...