3 Replies Latest reply on Nov 25, 2008 11:07 AM by TSGal

# help with calculation

### Title

help with calculation

### Post

Hello,

i am wondering if someone can help me out with this. basically i have this database of students, each student get assign enrollment  status: Enrolled, non-start and applied. Each student get assign a funding officer. also they get  second status for the funding source: SLM or PIF. Now, I need to figure way to find out  how many are SLM or PIF of those students which are enrolled. This is a summary report i am using to get the information base on funding officer. I am able to find the total for all the enrollement status and funding status but I need to figure a way to break apart base on funding status base on enrollment status. example will be

funding officer:

James smith,

Enrolled=50

Non-start=10

Applied=5

Now, out of the 50 students  that are enrolled, how many are SLM and PIF.

Thank you

Vic

• ###### 1. Re: help with calculation

Victor:

I still don't know what constitutes SLM or PIF.  You said this is based on the funding officer.  Why can't you run the report based on a calculation based upon the funding officer.  That is, the funding officer probably comes from a table along with the SLM or PIF status.  Correct?  You can then use this information in the summary report.

TSGal

FileMaker, Inc.

• ###### 2. Re: help with calculation

TS,

SLM and PIF constitutes how the students are funded, those are shortcut for: pay in full and sallie mae.  I am  using the funding officer to do my summary report to the break down the enrollment status. Now i need to figure out how to get the funding status base on the enrollment status for each funding officer. let say i have funding officer james smith, how the 50 he has enrolled. how many are SLM and PIF.   i am able to get all the total for the enrollment statuses but not for each individual one.

thank you

• ###### 3. Re: help with calculation

Victor:

If you have the 50 enrolled, you should have the status of those 50.  For simplistic case, 25 SLM and 25 PIF.  In your sub-summary by students, where you show how many are enrolled, you can add an additional sub-summary when sorted by status to break it down even further.  That is:

funding officer:

James smith,

Enrolled=50

PIF = 25

SLM = 25

Non-start=10

PIF=1

SLM=9

Applied=5

PIF=2

SLM=3

Or, you could create a new layout and substitute the Enrolled/Non-Start/Applied field with the Status field.  It could then look like:

funding officer:

James smith,

PIF=28

SLM=37

Let me know if I'm on the right track.

TSGal

FileMaker, Inc.