Jump to content

Summary Report - Determine Percentage

Recommended Posts

I feel a little sheepish asking this because I've done it many times before but just can't remember how to do it today; too stressed out from not being able to buy eggs, milk, bread, toilet paper...


What I want to do (in Layout 2 after sub-summarizing/sorting by Course Name then Risk Level)  is show the percentage of the Student Count ( = 150) to the right of the Risk Level, e.g.,


Achieving 96 (64%)

At RIsk 6 ( 4%)

Early Alert 48 ( 32%)


I tried the calculation, 

( RiskLevel__lxs / StudentCount__lxs ) * 100

...but that doesn't work. *heavy sigh* I feel sooooo dense.

Thanks in advance for your help.

Summary Example.fmp12

Edited by WF7A
Link to post
Share on other sites

Thanks. I've read and re-read your link's post and I still don't "get it." *heavy sigh* I'll keep at it.

Indeed, the unnecessary scarcity of common foods and goods is a sobering reminder that we more to fear from each other than anything Nature can throw at us.

Link to post
Share on other sites
Posted (edited)

On edit:  *smile*  Timing's everything--I figured it out just before you posted, Comment.

I was going write, "Great minds think alike," but I don't hold a candle to yours. Thank you!

Edited by WF7A
Link to post
Share on other sites

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...

Important Information

By using this site, you agree to our Terms of Use.