I have a layout that includes two sub-summaries. The topmost includes a summary field called studentGradeCount, which counts the number of students in a given grade.

The subordinate sub-summary contains applicationStatusCount, which is a summary field providing a count of applicationStatus.

Adjacent to the status count, I would like to provide a percentage, indicating what percent of the students have applications at each status. Logically, it would be

applicationStatusCount / studentGradeCount

But FileMaker doesn't return anything when I attempt this. Any help would be appreciated.

FMPA 16.0.3
macOS 10.13.3

 

All fields should be numbers, with a result of number?

Try 

Round (No Action  / Grade 01 ; 2 )

Round (Submitted  / Grade 01 ; 2 )

Round (Imported  / Grade 01 ; 2 )

I'm afraid that I don't follow. I can't hard-code specific statuses. That summary field is counting them on the fly.

Sorry, my eyes went directly to your graphic.

try changing the Grade 01 field to be 

Sum ( Imported ;  NoAction ; Submitted )

If this doesn't do it, rather than me recreate your file from your description, please post a copy or a markup of your file. 

Edited January 30, 20187 yr by Lee Smith
added Sum Field

Does this help?

The report can have too many variables and I would need to see your file, or a markup. Here is a short post that explains how to deal with confidential information.

Anatomy of a Good Topic, Step 9.

I think I've found a satisfactory workaround. Thank you very much for your time.