Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 2480 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

 

5a70b84e56062_ScreenShot2018-01-30at11_54_40AM.png.768dd0c81110e06f527a920d2e88a3cf.png

Posted

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 )

Posted

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

Posted (edited)

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 by Lee Smith
added Sum Field
Posted

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.

Posted

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

 

This topic is 2480 days old. Please don't post here. Open a new topic instead.

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.