Creating a Calulation

[perezla]

I am try to create a calculation that will give me a report of student count based on the value list of their college level. (freshman, sophmore, junior, senior). I am have trouble trying to work out the equation. Please help.

[Fitch]

Let's assume you have at least one field that is never empty, e.g. Student ID.

- Make a summary field that is the count of Student ID.

- Make a layout with a subsummary part, with college level as the sort field.*

- Put the college level field and the summary field on the subsummary part.

- Sort by college level.

- Preview or Print.

You may want to find all before running this report.

*The new layout dialog will guide you through these steps, including creating a script to run the report.

[perezla]

This was helpful, but I want to see all four catagory totals on the same layout without having to scroll or find the next total. Is this possible?

[comment]

See if this helps:

http://www.fmforums.com/forum/showtopic.php?tid/165331/

[perezla]

The data I'm working with is Student ID, value list "College Level" on the Student table.

[Raybaudi]

All fields are required. Your privacy is important to us. We do not share our data with anyone outside of UCR or the EAP system.

I would suggest to delete your file and to post an empty one.

[Fitch]

I want to see all four category totals on the same layout without having to scroll or find the next total.

If you use the method I proposed, and remove the Body part from the layout, you'll see all categories without scrolling.

If you want to be able to see the totals in Browse mode, that's another story: you'll want to use a different method altogether.

[perezla]

Thank you so much. One last question is there a way to get this information with out having to sort?

[Fitch]

There are other ways to approach this, but with a subsummary report you must sort.

[perezla]

are you able to supply an example?

[Fitch]

Look at the relationship graph in the first attached file. For each value we want to total, we have a global field, a table occurrence/relationship, and a calculation field for the total. That's a lot of overhead, so why would you want to do it this way: the totals are independent of the found set of records.

Now, that may not be important, or possibly you do want the found set to affect the totals. In that case you could use the technique from the second attached file. There we have a calculation for each value, and a summary field for each total.

college.zip

college2.zip

[perezla]

Thank you!

[perezla]

I think this will be my last question regarding this topic. I used the example from the college2 zip. This works for one portion of my report.

I am now trying to make and average calculation based on the count. I tried doing the calculation similar to college2 zip but that does't work.

[Fitch]

Hmmm, it's not clear to me what would make sense to average here.

What I didn't include in that file was a Summary field for the total found count, so make one called Total and make it the Count of id.

Then make a calc for each class, e.g.:

total09/Total

That gives us the percentage of the total students that are freshmen, is that what you're after?

[perezla]

Yes Thank You